Advanced Search

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged sql

1 ... 4 5 6 7 8 ... 12
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 2080 posted 13 years ago by denakitan
Search SQL Server or Oracle database for keyword embedded within stored procedures, functions, triggers, etc.
0 1140 posted 13 years ago by jstrawther
Can be used when looking for values that are duplicates.
0 910 posted 13 years ago by BrentS
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 1090 posted 13 years ago by iroybot
This query will retrieve a list of the parameters and value sets based on a provided concurrent program user name
0 1665 posted 13 years ago by theonlyalterego
Can use second, Minute and many other from the url above
0 992 posted 13 years ago by jsturtevant
Where clause to select multiple rows of unique values
0 1141 posted 13 years ago by the_construct
Query to find the most recent logins for a particular user ( find 1 years worth )
0 1310 posted 13 years ago by theonlyalterego
This code allows you to create an ID field value for inserts into a table that does not auto increment itself
0 1164 posted 13 years ago by ezerick
Searches for duplicate entries in the DataBase table
1 885 posted 13 years ago by Neven
intfield has this format: YYYYMMDD
0 3342 posted 13 years ago by wnasich
0 1111 posted 13 years ago by danfsmith
0 810 posted 13 years ago by amos24c
A slight adaptation on the sql in the Oracle Forum
0 1471 posted 13 years ago by theonlyalterego
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 910 posted 14 years ago by alberomo
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 1021 posted 14 years ago by alberomo
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 1023 posted 14 years ago by alberomo
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 1019 posted 14 years ago by alberomo
Kill connections to a database to perform maintenance that requires a connectionless DB
0 749 posted 14 years ago by sommertim
The inner join could be nested too
0 1326 posted 14 years ago by preasha
Select rows that are 3 months ahead or 3 months behind from the current date.
0 969 posted 14 years ago by jafar
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 1020 posted 14 years ago by Whiteagle
[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 1889 posted 14 years ago by eddequincey
0 1016 posted 14 years ago by samwa
Very useful sql to find which responsibility has access to a report or request.
0 2778 posted 14 years ago by theonlyalterego
Get the value of the autonumber field for the last record inserted into an Access database via the current connection.
0 1248 posted 14 years ago by wizard04
http://beyondrelational.com/ask/nakul/questions/10/how-to-remove-server-name-item-from-sql-server-management-studio.aspx
0 2395 posted 14 years ago by derebus
1 ... 4 5 6 7 8 ... 12