Advanced Search

Welcome To Snipplr

Everyone's Recent SQL Snippets

1 2 3 4 5 6 7 ... 18
stored procedure for executing batch sql statements
0 828 posted 8 years ago by ktrout
creates a minimal calendar table
0 1077 posted 8 years ago by ktrout
one cross join for each ai in definition of decimal number as sum(ai*10^i)
0 845 posted 8 years ago by ktrout
Moving a wordpress site for local dev, to staging, to production? This SQL snippet has done the job more often than not. It may not be 100% full proof but it has saved my butt hundreds of times. Please, if you know other tables or enhancements share...
0 945 posted 9 years ago by brownrl
This only shows public procedures, not the privates one declares only in packages body.
0 731 posted 9 years ago by Igeco
This piece of sql is used to find the similarity of one item to other items based on a 3 table tag system, cities, cities_tags, tags. It works in sQlite and MySQL. Use this code to get the idea of how you would make a "item" has "related items" based...
0 817 posted 9 years ago by brownrl
search database for column names http://vyaskn.tripod.com/sql_server_search_and_replace.htm EXEC SearchAllTables 'Computer' GO
0 847 posted 10 years ago by kat
search database for column names
0 856 posted 10 years ago by kat
La première commande liste les sessions bloquantes, la deuxième les kill
0 781 posted 10 years ago by Igeco
Confirm the sql script file is encoded with `UTF-8`
0 1023 posted 10 years ago by jacktan
caching session variables in Mysql using memory engine for fast client response. note: please test before use, then use at your own risk.
0 1370 posted 10 years ago by prgrmmraben
Here you may find some useful snippets for calculating relative time for different purposes: to get info from a column within certain date, like the latest 7 days, to get time interval etc.
0 895 posted 10 years ago by apphp-snippets
from codeproject
0 1107 posted 10 years ago by hairajeshk
Data types and ranges for Microsoft Access, MySQL and SQL Server.
0 631 posted 10 years ago by chrispantelis
New SQL Record = Populate TimeStamp Field with GetDate() Function
0 888 posted 10 years ago by chrispantelis
If you want to make a copy of the table including all of the data, then leave out the WHERE clause.
0 736 posted 10 years ago by chrispantelis
Parse xml (passed as a parameter) in SQL
0 873 posted 10 years ago by rralhan
Drop store procedures
0 756 posted 10 years ago by ironcrema
Adding a linked server to MSSQL account - particularly a MYSQL server
0 712 posted 10 years ago by kidmizere
Función sql que devuelve una tabla. parametros ID, cadena, caracter_slit
0 811 posted 10 years ago by ironcrema
Example: CREATE SCHEMA `db_wordpress_02` ; GRANT ALL PRIVILEGES ON db_wordpress_02.* to 'root'@'localhost' IDENTIFIED BY 'scr1ptlov3r';
1 849 posted 10 years ago by ampt
Extrae subcadena de cadena separado por caracter
0 721 posted 11 years ago by ironcrema
Agrega Llave Foránea
0 670 posted 11 years ago by ironcrema
List locked object Oracle Database using V$LOCKED_OBJECT view
0 744 posted 11 years ago by ceduard0
How to change user password for a wordpress site.
0 835 posted 11 years ago by keidash
How to get a query based on case/when sintax, on WHERE statement (Treated as boolean expresion)
0 642 posted 11 years ago by keidash
This will create a table, create an update trigger to add current datetime to modify_date field, do 2 inserts, 1 update and display the results.
0 777 posted 11 years ago by kidmizere
using this code in a stored procedure you can reset the seed of the identity column in sql server database
0 772 posted 11 years ago by PalCoder
This SQL would help you to transpose a rows into columns in SQL
0 2255 posted 11 years ago by mprabhuram
How to get onlye the time in SQL
0 724 posted 11 years ago by keidash
1 2 3 4 5 6 7 ... 18