Advanced Search

Welcome To Snipplr

Everyone's Recent Snippets Tagged sql

1 ... 6 7 8 9 10 ... 17
0 762 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 1155 posted 12 years ago by theonlyalterego
0 709 posted 12 years ago by silentpro
0 583 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 1021 posted 12 years ago by emregulcan
1 535 posted 12 years ago by samwa
Per cambiare il tipo di dato in una colonna devo fare un giretto...
0 552 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 4436 posted 12 years ago by Mithun
drop_tables_like(pattern, db)
0 543 posted 13 years ago by abstraktor
Just a simple php insert script.
0 605 posted 13 years ago by JonnySnip3r
0 543 posted 13 years ago by hairajeshk
Snip it if you keep forgetting how its done.
1 682 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 673 posted 13 years ago by fengelz
0 499 posted 13 years ago by kashif21
0 500 posted 13 years ago by kashif21
0 1174 posted 13 years ago by kashif21
this will delete where uniqueField is greater
1 677 posted 13 years ago by samwa
1 659 posted 13 years ago by samwa
Find duplicate records regarding a certain field.
0 451 posted 13 years ago by marvin9000
1 690 posted 13 years ago by samwa
This was a school project, so it is not well commented but feel free to ask details.
0 714 posted 13 years ago by sp4ke
Similar to "FIND_IN_SET" from MySQL.
0 678 posted 13 years ago by dotNetkow
(Grabs all info that matches both tables)
0 448 posted 13 years ago by staley412
0 487 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 461 posted 13 years ago by emregulcan
1 ... 6 7 8 9 10 ... 17