Welcome To Snipplr


Everyone's Recent SQL Snippets Tagged sql



1 ... 8 9 10 11 12 Next »
4 1224 posted 17 years ago by wolfie
1 1255 posted 17 years ago by zingo
0 923 posted 17 years ago by Caliban
Generate the SQL necessary to create triggers that use the sequences listed above. NOTE: This particular script assumes that the tables all start with ‘tbl’. It may need to be modified to work with different naming conventions.
0 966 posted 17 years ago by thecrumb
Generate the SQL necessary to create sequences for every table. NOTE: This doesn’t create sequences. The results need to be copied and run as a script.
0 1203 posted 17 years ago by thecrumb
Get a list of all the user tables.
0 1321 posted 17 years ago by thecrumb
Get all my columns and comments.
0 967 posted 17 years ago by thecrumb
Noob stuff, but I always end up looking this up.
0 991 posted 17 years ago by rengber
Small query to help you relocate those modules you are not using anyways.
2 1087 posted 17 years ago by torkil
If you are deleting all the rows in a table and you also want to reset the values that will get used by auto increment, this is how to do it.
0 1161 posted 17 years ago by jachin
You can generate a simple bar chart of the values by executing this command...
0 1144 posted 17 years ago by zingo
0 996 posted 17 years ago by rengber
1 1056 posted 18 years ago by Shpigford
This will return the number of seconds between now and when the time field was inserted.
0 1252 posted 18 years ago by wolfie
7 1189 posted 18 years ago by brentroady
Esta consulta nos permite comprobar si los registros obtenidos por dos consultas o vistas que operan de diferente forma son los mismos en ambos casos. Conviene adaptar las partes de la consulta de manera que se obtengan los resultados de nuestras dos...
0 932 posted 19 years ago by jomaweb
Example usage: exec sp_easypaging '[tblmessages]','[tblmessages].recid','','*','1 = 1','recid',1,5
0 1307 posted 19 years ago by planetthoughtful
1 ... 8 9 10 11 12 Next »