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 526 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 510 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 553 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 399 posted 12 years ago by sommertim

SQL Restore MSSQL database from backup (.bak)

0 632 posted 12 years ago by plugables

SQL Update table with values selected in a subquery

The inner join could be nested too

0 763 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 527 posted 12 years ago by jafar

Other To makes Pages and Posts current

0 573 posted 12 years ago by sridhar

PHP Limpiar variables $_POST/$_GET contra SQL Injection PHP

Esta funcion limpia un array contra inyecciÃ³n SQL.

0 1028 posted 12 years ago by n19ht

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

0 817 posted 12 years ago by theonlyalterego

ActionScript 3 WordPress - check if user exists by ID

0 709 posted 12 years ago by digitalzoomstudio

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 549 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 1200 posted 12 years ago by eddequincey

Java Simple H2 Database utility class

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 793 posted 12 years ago by studioevoque

PL/SQL Strategy to identify duplicates in an ETL context (for example)

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 855 posted 12 years ago by xavsio4

SQL sql group by top

0 540 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 1859 posted 12 years ago by theonlyalterego

PHP CakePHP: SQL-log in array (for controller, e.g.)

0 715 posted 12 years ago by kentandre

MySQL Selecting domain from email

0 381 posted 12 years ago by Ez3k

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.