Advanced Search

Welcome To Snipplr

Everyone's Recent Snippets Tagged sql

1 ... 6 7 8 9 10 ... 17
0 748 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 1147 posted 12 years ago by theonlyalterego
0 698 posted 12 years ago by silentpro
0 573 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 1010 posted 12 years ago by emregulcan
1 527 posted 12 years ago by samwa
Per cambiare il tipo di dato in una colonna devo fare un giretto...
0 545 posted 12 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 4424 posted 12 years ago by Mithun
drop_tables_like(pattern, db)
0 533 posted 13 years ago by abstraktor
Just a simple php insert script.
0 596 posted 13 years ago by JonnySnip3r
0 532 posted 13 years ago by hairajeshk
Snip it if you keep forgetting how its done.
1 675 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 661 posted 13 years ago by fengelz
0 489 posted 13 years ago by kashif21
0 493 posted 13 years ago by kashif21
0 1162 posted 13 years ago by kashif21
this will delete where uniqueField is greater
1 664 posted 13 years ago by samwa
1 647 posted 13 years ago by samwa
Find duplicate records regarding a certain field.
0 443 posted 13 years ago by marvin9000
1 677 posted 13 years ago by samwa
This was a school project, so it is not well commented but feel free to ask details.
0 706 posted 13 years ago by sp4ke
Similar to "FIND_IN_SET" from MySQL.
0 667 posted 13 years ago by dotNetkow
(Grabs all info that matches both tables)
0 444 posted 13 years ago by staley412
0 474 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 455 posted 13 years ago by emregulcan
1 ... 6 7 8 9 10 ... 17