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 1433 posted 9 years ago by bbrumm

SQL Oracle EXP Function

A few examples of the EXP function.

0 1690 posted 9 years ago by bbrumm

SQL Oracle TO_NUMBER Function

A few examples of the TO_NUMBER function

0 1702 posted 9 years ago by bbrumm

SQL Oracle RPAD Function

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

0 1388 posted 9 years ago by bbrumm

SQL Oracle LENGTH Function

A few examples of the LENGTH function

0 1367 posted 9 years ago by bbrumm

SQL Oracle LTRIM Function

A few examples of the Oracle LTRIM function.

0 1412 posted 9 years ago by bbrumm

SQL Oracle INSTR Function

A few examples of the Oracle INSTR function.

0 1465 posted 9 years ago by bbrumm

SQL Oracle RTRIM Function

A few examples of the Oracle RTRIM function.

0 1448 posted 9 years ago by bbrumm

SQL Oracle CASE Expression

A few examples of the Oracle CASE expression

0 1243 posted 9 years ago by bbrumm

SQL Oracle REPLACE Function

A few examples of the Oracle REPLACE function

0 1277 posted 9 years ago by bbrumm

SQL Oracle GREATEST Function

A few examples of the GREATEST function

0 1439 posted 9 years ago by bbrumm

SQL Oracle LEAST Function

A few examples of the Oracle LEAST function

0 1518 posted 9 years ago by bbrumm

SQL Oracle LISTAGG Function with Examples

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

0 1972 posted 9 years ago by bbrumm

SQL Oracle NVL2 Function

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

0 1466 posted 9 years ago by bbrumm

SQL Oracle CONCAT Function

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

0 1395 posted 9 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 1275 posted 9 years ago by bbrumm

SQL Oracle TO_DATE Examples

These are some examples of the Oracle TO_DATE Function

0 1263 posted 9 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 2240 posted 9 years ago by rm1984

SQL SQL Server query sample using rank/dense_rank

SQL Server query sample using rank/dense_rank

0 1445 posted 10 years ago by ManuelToledo

SQL Insert bloqueando la tabla

Insertar registros bloqueando mientras se realiza el proceso.

0 1485 posted 10 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 3782 posted 10 years ago by systemergon

SQL Formatos de datos en SQL

Alternativas para formato de datos en sql server

0 1896 posted 10 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 1377 posted 10 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 1499 posted 10 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 3830 posted 11 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 2057 posted 11 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 2757 posted 11 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 5250 posted 11 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 4606 posted 11 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 1595 posted 11 years ago by Igeco