Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

sql page server Oracle mysql csv database wordpress error php code drupal date replace script security search xml function text order textmate update file query data list table excel backup customer load login ASP codeigniter magento simple user windows convert joomla math find copy json Business directory number path images Online log links template link Development api twitter best web format object cache mail email html javascript actionscript apache color download service android animation browser aspnet ajax

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged sql

« Prev 1 ... 4 5 6 7 8 ... 12 Next »

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 1326 posted 13 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 1037 posted 13 years ago by jstrawther

SQL sql_FindingDupValues

Can be used when looking for values that are duplicates.

0 812 posted 13 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 975 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 1485 posted 13 years ago by theonlyalterego

SQL Sql Date Difference

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

0 873 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 994 posted 13 years ago by the_construct

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 1193 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 1035 posted 13 years ago by ezerick

SQL Find duplicate entries

Searches for duplicate entries in the DataBase table

1 786 posted 13 years ago by Neven

SQL Convert integer to date using SQL in iSeries DB2

intfield has this format: YYYYMMDD

0 3131 posted 13 years ago by wnasich

SQL Find rows with last date of month

0 965 posted 13 years ago by danfsmith

SQL TSQL COVERING INDEX

0 712 posted 13 years ago by amos24c

SQL Oracle - Find which users have FND Diagnostic profile value set

A slight adaptation on the sql in the Oracle Forum

0 1374 posted 13 years ago by theonlyalterego

SQL Connect string for Oracle with sqlplus

1 1097 posted 13 years ago by blackthorne

SQL Sintaxis bÃ¡sica/habitual SQL para consulta tipo DELETE

SintÃ¡xis y clausulas mÃ¡s habituales para consulas SQL con clÃ¡usula DELETE que elimina uno o varios registros de la tabla que se especifica.

0 816 posted 13 years ago by alberomo

SQL Sintaxis bÃ¡sica/habitual SQL para consulta tipo UPDATE

SintÃ¡xis y clausulas mÃ¡s habituales para consulas SQL con clÃ¡usula UPDATE que actualiza/modifica uno o varios registros de la tabla que se especifica.

0 895 posted 13 years ago by alberomo

SQL Sintaxis bÃ¡sica/habitual SQL para consulta tipo INSERT INTO

SintÃ¡xis y clausulas mÃ¡s habituales para consulas SQL con clÃ¡usula INSERT INTO que aÃ±ade un nuevo registro a la tabla que se especifica.

0 879 posted 13 years ago by alberomo

SQL Sintaxis bÃ¡sica/habitual SQL para consulta tipo SELECT

SintÃ¡xis y clausulas mÃ¡s habituales para consulas SQL con clÃ¡usula SELECT que generen una nueva tabla con el resultado de la consulta. Su sintÃ¡xis genÃ©rica es SELECT [campos] FROM [tablas] WHERE [criterio]

0 910 posted 13 years ago by alberomo

SQL List and kill active DB connections

Kill connections to a database to perform maintenance that requires a connectionless DB

0 669 posted 13 years ago by sommertim

SQL Restore MSSQL database from backup (.bak)

0 1047 posted 13 years ago by plugables

SQL Update table with values selected in a subquery

The inner join could be nested too

0 1196 posted 13 years ago by preasha

SQL SQL SELECT 3 MONTHS +/-

Select rows that are 3 months ahead or 3 months behind from the current date.

0 843 posted 13 years ago by jafar

SQL Oracle - Find all responsibilities and concurrent program names based on the executable Name

0 1258 posted 13 years ago by theonlyalterego

SQL Insert/Update in one stored procedure

To start my new post area I will share a simple stored procedure that will check if a record exists, if so update it, otherwise create it; Simple hum?! Just Update it to your needs :)

0 906 posted 13 years ago by Whiteagle

SQL SQL Query to create a table in MySQL to store tweets

[Query related to PHP code to save tweets from the twitter search API to a MySQL database](http://snipplr.com/view/56994/save-tweets-using-php-from-the-twitter-search-api-to-a-mysql-database/ "PHP code to save tweets from the twitter search API to a...

0 1735 posted 13 years ago by eddequincey

SQL sql group by top

0 925 posted 13 years ago by samwa

SQL Oracle - sql to find what responsibility can run a request / report

Very useful sql to find which responsibility has access to a report or request.

0 2631 posted 14 years ago by theonlyalterego

SQL Get ID of last inserted record in Access

Get the value of the autonumber field for the last record inserted into an Access database via the current connection.

0 1131 posted 14 years ago by wizard04

SQL How to clear the history list from the \"servername\" field of SSMS Connect-to-server dialog box?

http://beyondrelational.com/ask/nakul/questions/10/how-to-remove-server-name-item-from-sql-server-management-studio.aspx

0 1573 posted 14 years ago by derebus