Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

sql page server Oracle mysql csv database wordpress error php code drupal date replace script security search xml function text order textmate update file query data list table excel backup customer load login ASP codeigniter magento simple user windows convert joomla math find copy json Business directory number path images Online log links template link Development api twitter best web format object cache mail email html javascript actionscript apache color download service android animation browser aspnet ajax array c forms

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged sql

« Prev 1 ... 8 9 10 11 12 Next »

SQL Update from select

4 2393 posted 18 years ago by wolfie

SQL TSQL to Reset a Tables Primary Key Autonumber

0 1811 posted 18 years ago by rengber

SQL Differences between two Tables

1 2150 posted 18 years ago by zingo

SQL Copy table into a new table

0 1662 posted 18 years ago by Caliban

SQL Generate the SQL necessary to create triggers (Oracle)

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 1752 posted 18 years ago by thecrumb

SQL Generate the SQL necessary to create sequences for every table (Oracle)

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 2135 posted 18 years ago by thecrumb

SQL Get a list of all the user tables (Oracle)

Get a list of all the user tables.

0 2404 posted 18 years ago by thecrumb

SQL Get Columns and Comments (Oracle)

Get all my columns and comments.

0 1729 posted 18 years ago by thecrumb

SQL Add a Constant Value to a RecordSet

Noob stuff, but I always end up looking this up.

0 1756 posted 18 years ago by rengber

SQL Move inactive Joomla 1.0 modules to the bottom of the modules list

Small query to help you relocate those modules you are not using anyways.

2 2130 posted 18 years ago by torkil

SQL Ordering multiple SELECT statements in a UNION

0 2120 posted 18 years ago by andyhartleeds

SQL Reset auto increment on a table

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 2068 posted 18 years ago by jachin

SQL Generate Simple Bar Charts From a MySQL Prompt

You can generate a simple bar chart of the values by executing this command...

0 2009 posted 18 years ago by zingo

SQL List all Stored Procedures in an Oracle Database

0 8369 posted 18 years ago by rengber

SQL Using a BitMask in a Where Clause

0 1742 posted 19 years ago by rengber

SQL Search Stored Procedure Code for a String

0 1697 posted 19 years ago by rengber

SQL Get the Code of a Stored Procedure as Text

0 2288 posted 19 years ago by rengber

SQL Script to Create a Script Granting EXECUTE to all Stored Procs in a DB

0 2545 posted 19 years ago by rengber

SQL MySQL error reporting

1 1864 posted 19 years ago by Shpigford

SQL How to determine a timeout using unix time in mysql

This will return the number of seconds between now and when the time field was inserted.

0 2453 posted 19 years ago by wolfie

SQL Load CSV into MySQL

7 2441 posted 20 years ago by brentroady

SQL comprobar registros identicos de dos consultas

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 1664 posted 20 years ago by jomaweb

SQL SQLServer 2000 T-SQL Stored Procedure for providing paginated results

Example usage: exec sp_easypaging '[tblmessages]','[tblmessages].recid','','*','1 = 1','recid',1,5

0 2322 posted 20 years ago by planetthoughtful