sql codes

UPDATE, falls Eintrag schon vorhanden, sonst INSERT

Logical Expressions In SQL

Set MySQL root password

Grant MySQL Privileges

Storing an IP address in a database table

Django: dump SQL data into an xml file

MySQL random password string

Using Proc SQL to summarize tables into groupings

Postgres output CSV

Comma-Delimited List using Coalesce

Match Merge using Proc SQL

MySQL Table - ISO Country List with Abbreviations

MySQL Table - US States

Importing data from (Excel) CSV into MySQL

MySQL Find and Replace Drupal filepaths in files table

Convert an Oracle SQL DATE to a STRING in the form CCYYMMDD

Delete Dulicate Rows in MySQL

from_unixtime sql

SQL Rebuild Dev Database

SQL Shrink Transaction Log

50 States & Washington D.C.

Find all categories NOT used in current item

Use Regular Expressions in Proc SQL

Change user password in mediawiki

update a field in mysql

Wordpress "prepare" function for inserting into database

Import data from tab - delimited datafile to SQL table.

Select aléatoire avec MySQL 5

Sort results by order in list

MySQL reset autoindex

DOS command to run all SQL scripts in a path

SQL case sensitive match for user and password

ASP show a sql table

MySQL disable foreign key constraint check

Nested list from grouped sql

MYSQL add counter in query

Copy selection from one table to another with changes

mysql update replace

mysql php get enum values

Select the primary key for a table

get random record from mysql

Duplicate or clone one or more rows in MySQL

CI CRUD Model - JOIN Example

rename a column is MS SQL

user innodb in mysql

Creating a random password using dictionary table

Database Connection Class

Selecting a Random Row In Microsoft SQL Server

Selecting a Random Row From Oracle

Getting Count's with a UNION of two tables

MySQL Capitalize

Select random row from a SQL database.

SQL query per caricare nodi specifici in Drupal 2

Execute SQL Scalar Select with ASP.NET 3.5

Add custom column in Propel

Basic TSQL Cursor Syntax

TSQL to Start a Job Programatically

Remove time from datetime

TSQL Try Catch Error Handling

Full REST JSON MySQL Management Class

JSON To SQL Generator (JQUERY)

MySQL JSON Schema Tree

MySQL table size, number of rows, and size of indexes

Clean variables from SQL injections

Connect SQL Server to a Windows Shared Folder

sql: Create minimum table

Randomize Query in SQL

Extract logins default db

Adding GIS Support to Postgresql

Replace the wildcard-character with defined charater for SQL queries

Oracle SQL - Select OAF File version history

Last Backup Date for All databases

BIRT repts - vortex monthly uniques

Search Function-Responsibility relation

Simple SubSonic Collection Query

Return a table list with row count

Postgres replace

ASP.net: Retrieve connection string from web.config

Converting Dates in SQL Server

ASP.net: Update SQL from a DropDownList dynamically created in a GridView.

TSQL Backup / Restore

Change owner on sql server db.

Foreign Keys & DB Design

Clean array for Posting / SQL injection protection

Count Rows in Sql

Use drush sql dump to dump the database to the file system.

sqlDataObj in PHP5

Create SQL OR ID List

TSQL Function and Check Constraint to Ensure that a Parent Value is Present in the Table

Search stored procedures for string

Full Backup Script

Full Backup Script With Device

CodeIgniter Session Table SQL

Redux Auth Table SQL

SQL Server String Split Function

Basic script for prevert SQL inj and XSS

Copy a table from one database to another

TSQL to Get the SQL Autonumber ID of the Row Just Inserted

TSQL Convert DateTime