sql codes

SQL Template - Add Column

SQL Template - Drop Column

cronjob to optimize MySQL database

sql Raiserror with parameters

SQL Inserted Trigger

SQL Server 2008 Truncate Transaction Log

Shrink all development databases

INNER JOIN (Grabs all info that matches both tables)

Convert Drupal path_redirect to WordPress Plugin Redirection

Specify order of rows returned in MS SQL Server

Prepare sql in advance

Delete Magento test orders

Search for a text in all databases - SQLServerCentral

Light sql like database written in Bash

Method to import MySQL Scripts to MS SQL

sql order by with case

Find SQL duplicates

Find duplicate rows in a table

Delete duplicate rows from a table

sql query using javascript

Test String is numeric

SQl Select cluase value conversion

SQL Value conversion function

Inserting Data With C# and parameterized values

Reading data into a dataset in C#

Dynamic sql more than 4000 chars

Simple Database Insert

Xml element insertion in XML DATA

Xml Element and data insert ,deletion ,updation

SQL SERVER – Useful DateTime Functions to Find Specific Dates

alle Tabellen eines bestimmten Musters aus einer Datenbank löschen

Complete example of Triggers in insert,Update and delete scenario

magento translate global attributes

Load Postgres database with psql dump

Updated mysql database from SQL dump

Count number of tables, views, stored procedures or functions

Cambiare tipo in colonna ORACLE

More Efficient Method for Paging

Check SqlDataReader Column Is Exists (extension method)

SQL - Find Duplicate Rows

SQL - Find Table by Name

Oracle Application - List Responsibilities and Responsibility Keys that are assigned to a user

Find & Replace Text With MySQL

UTF-8 repair TYPO3

Search and Replace in MySQL Databases

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

Get ID of last inserted record in Access

Selecting domain from email

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

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

sql group by top

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

Simple H2 Database utility class

SQL Query to create a table in MySQL to store tweets

Insert/Update in one stored procedure

WordPress - check if user exists by ID

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

Limpiar variables $_POST/$_GET contra SQL Injection PHP

Replace local db with new URL

To makes Pages and Posts current

WordPress Migration - SQL for Uploads

SQL SELECT 3 MONTHS +/-

SQL Update With Join

Mssql update or insert

Cursor in Mysql

Schema for the database DVD

Update table with values selected in a subquery

Restore MSSQL database from backup (.bak)

List and kill active DB connections

Sintaxis básica/habitual SQL para consulta tipo SELECT

Sintaxis básica/habitual SQL para consulta tipo INSERT INTO

Sintaxis básica/habitual SQL para consulta tipo UPDATE

Sintaxis básica/habitual SQL para consulta tipo DELETE

if mysql_query is not empty

PHP Connexion to Mysql DDBB, SQL query and creation of a Record Set.

Database php class

Connect string for Oracle with sqlplus

Codeigniter: show SQL query from Active Record

US & CANADA Cities Database

T-SQL Error Handling

Oracle - Find which users have FND Diagnostic profile value set

Login to Drupal while site in maintenance

TSQL COVERING INDEX

Maps an existing database user to a SQL Server login.

Find rows with last date of month

Convert integer to date using SQL in iSeries DB2

Find duplicate entries

Auto Incremementing Id for Insert in T-SQL table

Oracle SQL - get a list of most recent user logins

Clean up expired django.contrib.session\'s in a huge MySQL InnoDB table

Where clause to select multiple rows of unique values

Sql Date Difference

Query to find Parameters and Value Sets associated with a Concurrent Program

Oracle - get concurrent program runtime / eval performance

Oracle AP-SLA-GL Link Query

Dupliquer champs sql avec infos

Manual activation of a module in Joomla!

sql_FindingDupValues

Search DDL (stored procedures, functions, etc) for keywords

SQL - SQL Server - Add Column with Default Value and Check Constraint