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

SQL Oracle EXP Function

A few examples of the EXP function.

0 854 posted 7 years ago by bbrumm

SQL Oracle TO_NUMBER Function

A few examples of the TO_NUMBER function

0 883 posted 7 years ago by bbrumm

SQL Oracle RPAD Function

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

0 736 posted 7 years ago by bbrumm

SQL Oracle LENGTH Function

A few examples of the LENGTH function

0 663 posted 7 years ago by bbrumm

SQL Oracle LTRIM Function

A few examples of the Oracle LTRIM function.

0 698 posted 7 years ago by bbrumm

SQL Oracle INSTR Function

A few examples of the Oracle INSTR function.

0 731 posted 7 years ago by bbrumm

SQL Oracle RTRIM Function

A few examples of the Oracle RTRIM function.

0 717 posted 7 years ago by bbrumm

SQL Oracle CASE Expression

A few examples of the Oracle CASE expression

0 610 posted 7 years ago by bbrumm

SQL Oracle REPLACE Function

A few examples of the Oracle REPLACE function

0 619 posted 7 years ago by bbrumm

SQL Oracle GREATEST Function

A few examples of the GREATEST function

0 729 posted 7 years ago by bbrumm

SQL Oracle LEAST Function

A few examples of the Oracle LEAST function

0 695 posted 7 years ago by bbrumm

SQL Oracle LISTAGG Function with Examples

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

0 1034 posted 7 years ago by bbrumm

SQL Oracle NVL2 Function

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

0 732 posted 7 years ago by bbrumm

SQL Oracle CONCAT Function

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

0 692 posted 7 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 626 posted 7 years ago by bbrumm

SQL Oracle TO_DATE Examples

These are some examples of the Oracle TO_DATE Function

0 614 posted 7 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 1156 posted 8 years ago by rm1984

SQL SQL Server query sample using rank/dense_rank

SQL Server query sample using rank/dense_rank

0 647 posted 8 years ago by ManuelToledo

SQL Insert bloqueando la tabla

Insertar registros bloqueando mientras se realiza el proceso.

0 627 posted 8 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 933 posted 8 years ago by systemergon

SQL Formatos de datos en SQL

Alternativas para formato de datos en sql server

0 773 posted 8 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 687 posted 8 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 719 posted 8 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 1025 posted 9 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 1003 posted 9 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 938 posted 9 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 2643 posted 9 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 1467 posted 9 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 721 posted 9 years ago by Igeco