sql codes

Create New User and Grant

SQL UPDATE SELECT

Normalize telephone numbers

Sanitize a PHP string for input into a Database

DISTINCT in Rails

Delete All Foreign Keys

Grab Plesk domain passwords

Grab Plesk FTP account passwords

Get Plesk FTP account passwords w/o logging into MySQL

Find all databases and login credentials

Importing a MySQL database in Windows

mysql_safe_query to prevent SQL injection

Convert Date/Time in SQL

Create a Temporary table within a SQL Stored Procedure

Reset Auto Increment for a Table

Joomla admin password reset

Wordpress - Custom loop SQL query (and Popular Posts example)

Calculating distance in Kilometres and Miles from Latitude and Longitude

Search functions for the occurance of a string

Find a Column by Name in User Tables

Pagination in SQL

Dump Table Data into CSV

Starting and stopping MySQL

Copy rows from one table to another

Search Database for Column Name

Search Database for string

Script table as INSERTS

Re-seed Identity Table

List all Stored Procs in Database

Common SQL Commands (create table, etc)

Search Stored Procedure for String

add 3 fields to clickforex table

move Drupal tags from one vocabulary into another

Query to get posts by category - Wordpress

Specify 'Order By' order

Reset Drupal admin password

Finding duplicates with SQL

createQuery(String, String)

getResultFromSQL(String) As Variant

LoneDatabaseClass

Create UTF8 Database

SQL: Create a user that has only access to one database

Reading XML String As Table

TSQL - Find All Empty Columns in a Database

Memory Clerks & used vas

Buffer pool usage per database

Cached Query Plans

Cached Query Plans per object type

Open transactions with text and plans

Percentage of IO for each database

Percentage of IO for each database and per driveletter

Wait stat list (user sessions)

Who is connected via SQL DAC

Index fragmentation in all db's per instance

Find tables without a clustered index

Return Cached Query Plans

Get current users and # sessions

Mysql: Change User Password

MYSQL : Calcul sur des dates avec des fonctions dans mysql

Cached SPs By Total Physical Reads (SQL 2008 only)

Page and row-count information for every partition in the current database

Display Missing Indexes of the Current DB ordered by Index Advantage

Display logfile size and usage via dbcc

Display logfile size and usage via dmv

List of single-use, ad-hoc queries that are bloating the plan cache

List of recovery model, log reuse wait description, log file size, log usage size and compatibility level for all databases on i

Index Read/Write/Fill Factor stats (current DB)

Find Tables in Database (SQL Query)

Search and Replace String in an SQL Server nText Field

Sistema de envíos Magento para Chile

MySQL - Most relevant weighted results based (MATCH AGAINST)

Bulk Delete Comments

Find Physical Files in SQL Server

Global search on DataBase

Collection of I/O specific DMV's

Copy database diagrams in SQL Server 2005

Get current users and connection type

list of current locks

List of current sessions causing blocking

Ranking Function - Range over partition - Oracle Analytical function

Search & Replace in MySQL DB

Postgresql find duplicate columns

Oracle - Overlaps function

How to avoid double counting

Clean Injection from Database Tables

Find all Foreign Keys in a SQL Server DB

Regular expression to convert alphanumeric field into numeric field

Prepared Statements: Read

Import Sql File into MySQL DB

Clean SQL Injection from your tables

mysql query to populate table from data in file

Return Multiple Values Stored Procedure

Oracle TimeStamp to Char conversion

Create/ View/ Delete DB Links in oracle

Push_subq Oracle hint - Execute the sub query before the parent query

Move Column in MySQL Table

SQL Searh in ALL DataBase

SQL Searh And Replace in ALL DataBase

Timezone database

MySQL Blob Compression performance query