Login / Register

Share Snipplr

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged sql

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 888 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 669 posted 12 years ago by jstrawther

SQL sql_FindingDupValues

Can be used when looking for values that are duplicates.

0 466 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 580 posted 12 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 955 posted 12 years ago by theonlyalterego

SQL Sql Date Difference

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

0 516 posted 12 years ago by jsturtevant

SQL Where clause to select multiple rows of unique values

Where clause to select multiple rows of unique values

0 619 posted 12 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 821 posted 12 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 689 posted 12 years ago by ezerick

SQL Find duplicate entries

Searches for duplicate entries in the DataBase table

1 488 posted 12 years ago by Neven

SQL Convert integer to date using SQL in iSeries DB2

intfield has this format: YYYYMMDD

0 2600 posted 12 years ago by wnasich

SQL Find rows with last date of month

0 626 posted 12 years ago by danfsmith

SQL TSQL COVERING INDEX

0 420 posted 12 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 876 posted 12 years ago by theonlyalterego

SQL Connect string for Oracle with sqlplus

1 632 posted 12 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 482 posted 12 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 533 posted 12 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 517 posted 12 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 558 posted 12 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 404 posted 12 years ago by sommertim

SQL Restore MSSQL database from backup (.bak)

0 643 posted 12 years ago by plugables

SQL Update table with values selected in a subquery

The inner join could be nested too

0 772 posted 12 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 533 posted 12 years ago by jafar

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

0 823 posted 12 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 556 posted 12 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 1207 posted 12 years ago by eddequincey

SQL sql group by top

0 547 posted 12 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 1871 posted 12 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 748 posted 12 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 1107 posted 12 years ago by derebus