Advanced Search

Welcome To Snipplr

Everyone's Recent Snippets Tagged sql

1 ... 5 6 7 8 9 ... 17
0 581 posted 13 years ago by amos24c
A slight adaptation on the sql in the Oracle Forum
0 1172 posted 13 years ago by theonlyalterego
3 2705 posted 13 years ago by frederichoule
That's something quick. A basic php class to manage properly a database. Thanks to magic methods opening a database is almost automatic.
1 1060 posted 13 years ago by claudiowebdesign
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 682 posted 13 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 755 posted 13 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 726 posted 13 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 758 posted 13 years ago by alberomo
Kill connections to a database to perform maintenance that requires a connectionless DB
0 567 posted 13 years ago by sommertim
The inner join could be nested too
0 1027 posted 13 years ago by preasha
Select rows that are 3 months ahead or 3 months behind from the current date.
0 713 posted 13 years ago by jafar
0 779 posted 13 years ago by sridhar
Esta funcion limpia un array contra inyección SQL.
0 1351 posted 13 years ago by n19ht
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 777 posted 13 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 1516 posted 13 years ago by eddequincey
A simple utility class that uses the H2 SQL Db to maintain a database connection. It also gives a convenience method to run SQL scripts. _Note:_The init.sql value is hardcoded, and should be replaced by a static variable if needed
0 1052 posted 13 years ago by studioevoque
This sql statement enables to detect duplicates entries over a key and creates a seq column which says which one is the sequence of the duplicates. This way you can take only the seq = 1 and still be able to identify all duplicates
0 1150 posted 13 years ago by xavsio4
0 764 posted 13 years ago by samwa
Very useful sql to find which responsibility has access to a report or request.
0 2393 posted 13 years ago by theonlyalterego
0 543 posted 13 years ago by Ez3k
Get the value of the autonumber field for the last record inserted into an Access database via the current connection.
0 990 posted 13 years ago by wizard04
http://beyondrelational.com/ask/nakul/questions/10/how-to-remove-server-name-item-from-sql-server-management-studio.aspx
0 1372 posted 13 years ago by derebus
0 1014 posted 13 years ago by iroybot
progress of converting a latin db into utf8
1 997 posted 13 years ago by Rito
1 ... 5 6 7 8 9 ... 17