Welcome To Snipplr
Everyone's Recent SQL Snippets Tagged sql
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
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
546
posted 16 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
789
posted 16 years ago by thecrumb
Small query to help you relocate those modules you are not using anyways.
2
695
posted 16 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
739
posted 16 years ago by jachin
You can generate a simple bar chart of the values by executing this command...
0
762
posted 16 years ago by zingo
This will return the number of seconds between now and when the time field was inserted.
0
808
posted 17 years ago by wolfie
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
573
posted 17 years ago by jomaweb
Example usage:
exec sp_easypaging '[tblmessages]','[tblmessages].recid','','*','1 = 1','recid',1,5
0
795
posted 17 years ago by planetthoughtful