Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

form regex email curl url http login css mysql database ajax javascript js sql class php header redirect table ie data dropdown sort list object date phone number format svn command resize image file textmate plugin path math actionscript event mail link window debug template Bash java search html post mac error xhtml page google wordpress server rails browser python script replace style array forms backup flash video ruby DOM xml category unix osx download simple c code windows navigation jquery cakephp regexp text function button links filter ie6 linux images htaccess apache free files copy log module query background

Welcome To Snipplr

Everyone's Recent Snippets Tagged sql

« Prev 1 2 3 4 5 6 ... 17 Next »

SQL Oracle CEIL Function

A few examples of the Oracle CEIL function.

0 1103 posted 8 years ago by bbrumm

SQL Oracle EXP Function

A few examples of the EXP function.

0 1290 posted 8 years ago by bbrumm

SQL Oracle TO_NUMBER Function

A few examples of the TO_NUMBER function

0 1292 posted 8 years ago by bbrumm

SQL Oracle RPAD Function

A few examples of the Oracle RPAD function, with some tables being set up.

0 1064 posted 8 years ago by bbrumm

SQL Oracle LENGTH Function

A few examples of the LENGTH function

0 1038 posted 8 years ago by bbrumm

SQL Oracle LTRIM Function

A few examples of the Oracle LTRIM function.

0 1087 posted 8 years ago by bbrumm

SQL Oracle INSTR Function

A few examples of the Oracle INSTR function.

0 1100 posted 8 years ago by bbrumm

SQL Oracle RTRIM Function

A few examples of the Oracle RTRIM function.

0 1117 posted 8 years ago by bbrumm

SQL Oracle CASE Expression

A few examples of the Oracle CASE expression

0 914 posted 8 years ago by bbrumm

SQL Oracle REPLACE Function

A few examples of the Oracle REPLACE function

0 943 posted 8 years ago by bbrumm

SQL Oracle GREATEST Function

A few examples of the GREATEST function

0 1086 posted 8 years ago by bbrumm

SQL Oracle LEAST Function

A few examples of the Oracle LEAST function

0 1108 posted 8 years ago by bbrumm

SQL Oracle LISTAGG Function with Examples

Some examples of the Oracle LISTAGG function, including setting up the tables.

0 1566 posted 8 years ago by bbrumm

SQL Oracle NVL2 Function

Some examples of the NVL2 function in Oracle, including setup table.

0 1135 posted 8 years ago by bbrumm

SQL Oracle CONCAT Function

A few examples of the CONCAT function, including setting up the example tables.

0 1085 posted 8 years ago by bbrumm

SQL Oracle TO_CHAR Examples

A few examples of the Oracle TO_CHAR function, which works on numbers and dates.

0 940 posted 8 years ago by bbrumm

SQL Oracle TO_DATE Examples

These are some examples of the Oracle TO_DATE Function

0 933 posted 8 years ago by bbrumm

MySQL Show the output of a query in a more readable vertical format

Show the output of a query in a more readable vertical format

0 1717 posted 9 years ago by rm1984

SQL SQL Server query sample using rank/dense_rank

SQL Server query sample using rank/dense_rank

0 1040 posted 9 years ago by ManuelToledo

SQL Insert bloqueando la tabla

Insertar registros bloqueando mientras se realiza el proceso.

0 1104 posted 9 years ago by systemergon

VB.NET Funcion conectar a BD SQL Server (sqlconection)

ConexiÃ³n a base de datos con los parametros que llega del contructor

0 3279 posted 9 years ago by systemergon

SQL Formatos de datos en SQL

Alternativas para formato de datos en sql server

0 1387 posted 9 years ago by systemergon

SQL Procedimiento almacenado devuelve todos los registros si no recibe parametros

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 1043 posted 9 years ago by systemergon

SQL Get rows coutn of all datatables of one database

This lite fiuntion is a simple organizator rowcount for all datatables for one single database.

0 1115 posted 9 years ago by achavesm302

MySQL Find last two updates to a record

Created as reply to question on ittoolbox.com:"Need your help in writing a query to pull audit history i.e. Last updated by a user 'XYZ' and for the same record key (ID) the second last record in the audit history table. i.e. Last update by this user...

0 3361 posted 10 years ago by bvwatson

Visual Basic Generate SQL query for column matching

Written as reply to question on ittoolbox.com:"I need to execute a query in vb which can find multiple value provided by the user to find from a single column of a table." [http://database.ittoolbox.com/groups/technical-functional/sql-l/query-to-fin...

0 1535 posted 10 years ago by bvwatson

SQL Migrate a Wordpress

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 2307 posted 10 years ago by brownrl

PHP PHP - Doctrine - Left join ON condition AND other condition syntax in Doctrine

In SQL I can get this by adding AND to the join LEFT JOIN installations i ON a.id = i.app AND i.page = :page This way I get the installation info for an app that has an installation on the page, but I get null values on the columns for app's that...

0 4443 posted 10 years ago by satie83

VB.NET VB.NET SQL Example: How to send SMS in VB.NET using SQL database

I thought I share this code snippet because I find this way of SMS sending an easy solution. I believe that even beginners can implement this VB.NET SQL SMS application, but I think some extent of perfection in the SMS technology is required for bett...

0 3973 posted 10 years ago by LoganTurn

SQL Get all procedures from Oracle packages

This only shows public procedures, not the privates one declares only in packages body.

0 1140 posted 10 years ago by Igeco