Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

form regex email curl url http login css mysql database ajax javascript js sql class php header redirect table ie data dropdown sort list object date phone number format svn command resize image file textmate plugin path math actionscript event mail link window debug template Bash java search html post mac error xhtml page google wordpress server rails browser python script replace style array forms backup flash video ruby DOM xml category unix osx download simple c code windows navigation jquery cakephp regexp text function button links filter ie6 linux images htaccess apache free files copy log module query background

Welcome To Snipplr

Everyone's Recent Snippets Tagged sql

« Prev 1 ... 6 7 8 9 10 ... 17 Next »

SQL Find & Replace Text With MySQL

0 2093 posted 15 years ago by BFTrick

PL/SQL Oracle Application - List Responsibilities and Responsibility Keys that are assigned to a user

I found this today and it's very useful for finding the responsibility key when trying ot run OAF from JDev.

0 2577 posted 15 years ago by theonlyalterego

Other SQL - Find Table by Name

0 2861 posted 15 years ago by silentpro

Other SQL - Find Duplicate Rows

0 1789 posted 15 years ago by silentpro

C# Check SqlDataReader Column Is Exists (extension method)

This snippet is "extension method" for IDataReader. You can use this snippet below ; I assume you have datareader like that SqlDataReader dataReader = command.ExecuteReader(); if (dataReader.IsColumnExists("columnName")) { //do something...

0 2654 posted 15 years ago by emregulcan

SQL More Efficient Method for Paging

1 1485 posted 15 years ago by samwa

SQL Cambiare tipo in colonna ORACLE

Per cambiare il tipo di dato in una colonna devo fare un giretto...

0 1519 posted 15 years ago by tuffo19

SQL Count number of tables, views, stored procedures or functions

You can use TSQL to Count Number Of Stored Procedures, Views, Tables or Functions in a Database by using the Database INFORMATION_SCHEMA view

0 7046 posted 15 years ago by Mithun

MySQL Updated mysql database from SQL dump

0 1991 posted 15 years ago by greeneggs614

Other Load Postgres database with psql dump

0 1716 posted 15 years ago by greeneggs614

SQL Complete example of Triggers in insert,Update and delete scenario

0 2385 posted 15 years ago by kashif21

MySQL alle Tabellen eines bestimmten Musters aus einer Datenbank lÃ¶schen

drop_tables_like(pattern, db)

0 1705 posted 15 years ago by abstraktor

SQL SQL SERVER â€“ Useful DateTime Functions to Find Specific Dates

0 2254 posted 15 years ago by kashif21

PHP Simple Database Insert

Just a simple php insert script.

0 1695 posted 15 years ago by JonnySnip3r

SQL Dynamic sql more than 4000 chars

0 1620 posted 15 years ago by hairajeshk

C# Reading data into a dataset in C#

Snip it if you keep forgetting how its done.

1 1985 posted 15 years ago by fengelz

C# Inserting Data With C# and parameterized values

Not that theres anything new to this. In fact its very old fashioned, but If you like me forget how its done; snip it.

0 1834 posted 15 years ago by fengelz

SQL SQL Value conversion function

0 1571 posted 15 years ago by kashif21

SQL SQl Select cluase value conversion

0 1511 posted 15 years ago by kashif21

JavaScript sql query using javascript

0 2541 posted 15 years ago by kashif21

SQL Delete duplicate rows from a table

this will delete where uniqueField is greater

1 1843 posted 15 years ago by samwa

SQL Find duplicate rows in a table

1 1844 posted 15 years ago by samwa

SQL Find SQL duplicates

Find duplicate records regarding a certain field.

0 1376 posted 15 years ago by marvin9000

SQL sql order by with case

1 1715 posted 15 years ago by samwa

Bash Light sql like database written in Bash

This was a school project, so it is not well commented but feel free to ask details.

0 1938 posted 15 years ago by sp4ke

SQL Specify order of rows returned in MS SQL Server

Similar to "FIND_IN_SET" from MySQL.

0 1838 posted 15 years ago by dotNetkow

SQL INNER JOIN (Grabs all info that matches both tables)

(Grabs all info that matches both tables)

0 1332 posted 15 years ago by staley412

SQL Shrink all development databases

0 1529 posted 15 years ago by scholli

SQL SQL Server 2008 Truncate Transaction Log

0 1623 posted 15 years ago by scholli

SQL SQL Inserted Trigger

This trigger returns a resultset that includes last inserted record's guid info (uniqueidentifier) If your column is uniqueidentifier and its default value is newid() , you can't get last record id (guid) with @@identity . So, I write a trigger...

1 1469 posted 15 years ago by emregulcan