Welcome To Snipplr


Everyone's Recent Snippets Tagged sql



1 ... 6 7 8 9 10 ... 17
0 2269 posted 15 years ago by BFTrick
I found this today and it's very useful for finding the responsibility key when trying ot run OAF from JDev.
0 2798 posted 15 years ago by theonlyalterego
0 3051 posted 15 years ago by silentpro
0 1946 posted 15 years ago by silentpro
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 2887 posted 15 years ago by emregulcan
1 1621 posted 15 years ago by samwa
Per cambiare il tipo di dato in una colonna devo fare un giretto...
0 1674 posted 15 years ago by tuffo19
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 7277 posted 15 years ago by Mithun
drop_tables_like(pattern, db)
0 1853 posted 15 years ago by abstraktor
Just a simple php insert script.
0 1867 posted 15 years ago by JonnySnip3r
0 1801 posted 15 years ago by hairajeshk
Snip it if you keep forgetting how its done.
1 2164 posted 15 years ago by fengelz
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 2014 posted 15 years ago by fengelz
0 1767 posted 15 years ago by kashif21
0 1669 posted 15 years ago by kashif21
0 2753 posted 15 years ago by kashif21
this will delete where uniqueField is greater
1 2007 posted 15 years ago by samwa
1 2004 posted 15 years ago by samwa
Find duplicate records regarding a certain field.
0 1520 posted 15 years ago by marvin9000
1 1905 posted 15 years ago by samwa
This was a school project, so it is not well commented but feel free to ask details.
0 2123 posted 15 years ago by sp4ke
Similar to "FIND_IN_SET" from MySQL.
0 2008 posted 15 years ago by dotNetkow
(Grabs all info that matches both tables)
0 1479 posted 15 years ago by staley412
0 1675 posted 15 years ago by scholli
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 1611 posted 15 years ago by emregulcan
1 ... 6 7 8 9 10 ... 17