Welcome To Snipplr


Everyone's Recent Snippets Tagged sql



1 ... 6 7 8 9 10 ... 17
0 1182 posted 14 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 1618 posted 14 years ago by theonlyalterego
0 1146 posted 14 years ago by silentpro
0 1029 posted 14 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 1678 posted 14 years ago by emregulcan
1 862 posted 14 years ago by samwa
Per cambiare il tipo di dato in una colonna devo fare un giretto...
0 919 posted 14 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 5717 posted 14 years ago by Mithun
drop_tables_like(pattern, db)
0 943 posted 14 years ago by abstraktor
Just a simple php insert script.
0 961 posted 14 years ago by JonnySnip3r
0 886 posted 14 years ago by hairajeshk
Snip it if you keep forgetting how its done.
1 1107 posted 14 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 1048 posted 14 years ago by fengelz
0 907 posted 14 years ago by kashif21
0 879 posted 14 years ago by kashif21
0 1650 posted 14 years ago by kashif21
this will delete where uniqueField is greater
1 1041 posted 14 years ago by samwa
1 1050 posted 14 years ago by samwa
Find duplicate records regarding a certain field.
0 783 posted 14 years ago by marvin9000
1 1042 posted 14 years ago by samwa
This was a school project, so it is not well commented but feel free to ask details.
0 1217 posted 14 years ago by sp4ke
Similar to "FIND_IN_SET" from MySQL.
0 1070 posted 14 years ago by dotNetkow
(Grabs all info that matches both tables)
0 782 posted 14 years ago by staley412
0 861 posted 14 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 904 posted 14 years ago by emregulcan
1 ... 6 7 8 9 10 ... 17