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 ... 4 5 6 7 8 ... 17 Next »

VB.NET VB.NET Method Perform Scalar

This is a method that can be used to take a connection string and a valid oledb command and perform a scalar. This returns an Integer/Int32 value.

0 1135 posted 12 years ago by nimblebits

SQL Get first day of month using datediff

One line to determine start of previous month

1 866 posted 12 years ago by snoopmole

MySQL What MySQL Table Has What Column

How to find a given column in a given database in MySQL

1 1026 posted 12 years ago by philsown

SQL Ver tablas asignadas a un usuario por privilegios

ver tablas que tiene un usario asiganadas por privilegio

0 4415 posted 12 years ago by thescorpion

SQL Grant y Revoke sobre objetos - dinamico

Uso de Grant y Revoke de objetos masivos de distintos user

0 829 posted 12 years ago by thescorpion

SQL Rename Column Name

http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/

0 767 posted 12 years ago by BrentS

MySQL create new database

Create a new database and its respective user with all privileges

0 791 posted 12 years ago by claudiodev

SQL Creacion de DBLINK con Full name service

Cuando se da el caso que tienes 2 servidores diferentes y el ServiceName de oracle es el mismo...En el momento de crear un dblink hay que especificar bien la cadena de coneccion para que se direccione al otro servidor y no escoja el serviceName del e...

0 768 posted 12 years ago by thescorpion

SQL Delete a limited set of rows in a DB2 database

Delete a defined number of rows from a db2 database table

0 867 posted 12 years ago by claudiodev

SQL Mostrar Objetos que hacen Referencia a un Objeto Especifico

Mostrar Objetos que hacen Referencia a un Objeto Especifico en Oracle

0 1021 posted 12 years ago by thescorpion

SQL SQL Date/Time Statements

SQL Server 2008 Date/Time Statements

0 664 posted 12 years ago by msstar

SQL Consultar el MB los tamaÃ±os y porcentaje libre de TableSpace Oracle

Consular los tablespace y mostrar su tamaÃ±o , uso y espacio libre en Megabyte

0 5041 posted 12 years ago by thescorpion

SQL SQL UPDATE using JOIN

SQL update examples using joins

1 861 posted 12 years ago by ed_trench

SQL Borra archivos LOG Oracle usando RMAN

Borrar archivos Log con Rman

0 1540 posted 12 years ago by thescorpion

SQL Oracle Find Profile Values for User

find what profile values are set for a particular user

0 921 posted 12 years ago by theonlyalterego

SQL Return last day of month

Input: Month and year number Output: Last day of month

0 787 posted 12 years ago by sjmoorecouk

PHP Prevent sql injection in LIKE queries

Function to prevent sql injection in Like queries, where the characters '_' and '%' can be dangerous.

0 1222 posted 12 years ago by TimoZachi

SQL SQL - SQL Server - Add Column with Default Value and Check Constraint

Example of SQL syntax to add a new column to an existing table, define a default value to the columns for the existing rows and also add a check constraint to limit the values that the column can hold.

0 1201 posted 12 years ago by denakitan

SQL Search DDL (stored procedures, functions, etc) for keywords

Search SQL Server or Oracle database for keyword embedded within stored procedures, functions, triggers, etc.

0 919 posted 12 years ago by jstrawther

SQL sql_FindingDupValues

Can be used when looking for values that are duplicates.

0 711 posted 12 years ago by BrentS

SQL Manual activation of a module in Joomla!

in order to avoid the .zip madness when creating a new module, you can make it available in the backend by firing a simple SQL in your DB. (mod_media is the name of the folder that holds it)

0 859 posted 13 years ago by iroybot

SQL Query to find Parameters and Value Sets associated with a Concurrent Program

This query will retrieve a list of the parameters and value sets based on a provided concurrent program user name

0 1339 posted 13 years ago by theonlyalterego

SQL Sql Date Difference

Can use second, Minute and many other from the url above

0 766 posted 13 years ago by jsturtevant

SQL Where clause to select multiple rows of unique values

Where clause to select multiple rows of unique values

0 880 posted 13 years ago by the_construct

Django Clean up expired django.contrib.session\'s in a huge MySQL InnoDB table

While django provides the django_admin.py cleanup script, if sessions get out of control sometimes you have to go lower level to get everything cleaned up. If the problem gets out of hand and you hit the resource limits of the machine, it is very dif...

0 1390 posted 13 years ago by magicrebirth

SQL Oracle SQL - get a list of most recent user logins

Query to find the most recent logins for a particular user ( find 1 years worth )

0 1078 posted 13 years ago by theonlyalterego

SQL Auto Incremementing Id for Insert in T-SQL table

This code allows you to create an ID field value for inserts into a table that does not auto increment itself

0 932 posted 13 years ago by ezerick

SQL Find duplicate entries

Searches for duplicate entries in the DataBase table

1 696 posted 13 years ago by Neven

SQL Convert integer to date using SQL in iSeries DB2

intfield has this format: YYYYMMDD

0 2966 posted 13 years ago by wnasich

SQL Find rows with last date of month

0 854 posted 13 years ago by danfsmith