Advanced Search

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged sql

1 2 3 4 5 6 ... 12
A few examples of the EXP function.
0 1045 posted 8 years ago by bbrumm
A few examples of the TO_NUMBER function
0 1081 posted 8 years ago by bbrumm
A few examples of the Oracle RPAD function, with some tables being set up.
0 916 posted 8 years ago by bbrumm
A few examples of the LENGTH function
0 853 posted 8 years ago by bbrumm
A few examples of the Oracle LTRIM function.
0 877 posted 8 years ago by bbrumm
A few examples of the Oracle INSTR function.
0 934 posted 8 years ago by bbrumm
A few examples of the Oracle RTRIM function.
0 921 posted 8 years ago by bbrumm
A few examples of the Oracle CASE expression
0 785 posted 8 years ago by bbrumm
A few examples of the Oracle REPLACE function
0 802 posted 8 years ago by bbrumm
A few examples of the GREATEST function
0 921 posted 8 years ago by bbrumm
A few examples of the Oracle LEAST function
0 920 posted 8 years ago by bbrumm
Some examples of the Oracle LISTAGG function, including setting up the tables.
0 1261 posted 8 years ago by bbrumm
Some examples of the NVL2 function in Oracle, including setup table.
0 965 posted 8 years ago by bbrumm
A few examples of the CONCAT function, including setting up the example tables.
0 904 posted 8 years ago by bbrumm
A few examples of the Oracle TO_CHAR function, which works on numbers and dates.
0 799 posted 8 years ago by bbrumm
These are some examples of the Oracle TO_DATE Function
0 791 posted 8 years ago by bbrumm
SQL Server query sample using rank/dense_rank
0 863 posted 9 years ago by ManuelToledo
Insertar registros bloqueando mientras se realiza el proceso.
0 833 posted 9 years ago by systemergon
Alternativas para formato de datos en sql server
0 1023 posted 9 years ago by systemergon
Cuando requerimos hacer consultas que devuelvan todos los registros y al mismo tiempo si se desea filtrar por algunos campos se filtra por los parámetros devueltos ej. en el WHERE (U.UnidadAplicativaId = @UnidadAplicativaId OR @UnidadAplicativaId...
0 871 posted 9 years ago by systemergon
This lite fiuntion is a simple organizator rowcount for all datatables for one single database.
0 914 posted 9 years ago by achavesm302
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 1148 posted 10 years ago by brownrl
This only shows public procedures, not the privates one declares only in packages body.
0 943 posted 10 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 1024 posted 10 years ago by brownrl
caching session variables in Mysql using memory engine for fast client response. note: please test before use, then use at your own risk.
0 1675 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 1119 posted 10 years ago by apphp-snippets
Data types and ranges for Microsoft Access, MySQL and SQL Server.
0 841 posted 11 years ago by chrispantelis
New SQL Record = Populate TimeStamp Field with GetDate() Function
0 1100 posted 11 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 939 posted 11 years ago by chrispantelis
Parse xml (passed as a parameter) in SQL
0 1093 posted 11 years ago by rralhan
1 2 3 4 5 6 ... 12