Advanced Search

Welcome To Snipplr

Everyone's Recent Snippets Tagged sql

1 ... 6 7 8 9 10 ... 17
0 764 posted 12 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 1157 posted 12 years ago by theonlyalterego
0 713 posted 12 years ago by silentpro
0 585 posted 12 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 1028 posted 12 years ago by emregulcan
1 541 posted 13 years ago by samwa
Per cambiare il tipo di dato in una colonna devo fare un giretto...
0 557 posted 13 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 4447 posted 13 years ago by Mithun
drop_tables_like(pattern, db)
0 550 posted 13 years ago by abstraktor
Just a simple php insert script.
0 607 posted 13 years ago by JonnySnip3r
0 546 posted 13 years ago by hairajeshk
Snip it if you keep forgetting how its done.
1 688 posted 13 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 674 posted 13 years ago by fengelz
0 503 posted 13 years ago by kashif21
0 504 posted 13 years ago by kashif21
0 1181 posted 13 years ago by kashif21
this will delete where uniqueField is greater
1 679 posted 13 years ago by samwa
1 663 posted 13 years ago by samwa
Find duplicate records regarding a certain field.
0 453 posted 13 years ago by marvin9000
1 694 posted 13 years ago by samwa
This was a school project, so it is not well commented but feel free to ask details.
0 717 posted 13 years ago by sp4ke
Similar to "FIND_IN_SET" from MySQL.
0 681 posted 13 years ago by dotNetkow
(Grabs all info that matches both tables)
0 453 posted 13 years ago by staley412
0 491 posted 13 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 467 posted 13 years ago by emregulcan
1 ... 6 7 8 9 10 ... 17