sql codes

Et cetra

PID MYSQL

sql practice test 20+ challenging queries

sql query interview question

Kali-python

SQLServer 2000 T-SQL Stored Procedure for providing paginated results

comprobar registros identicos de dos consultas

Oracle Stored Proc to Return a Recordset (Oracle Side)

Oracle DateTime Interval

Load CSV into MySQL

Command line instructions to create a database in MySQL

How to delete a database in MySQL

How to backup mysql database by command line (dump)

Migrate MySQL database from old host to a new host

Convertir une date SQL (YYYY-MM-DD) en date lisible

Select from WordpressMU Posts

Easy default options for methods in Ruby

Tag Cloud in Ruby

Easy Selects in Ruby on Rails

Change password in Oracle

MySQL import command

MySQL dump/export command

Delete a Table or Database

MySQL 3.23 Space after query gotya

php mysql/mysqli sql insert id

Python - Get id3 from MP3 File

How to determine a timeout using unix time in mysql

MySQL error reporting

list of users that never logged in

SQL Stored Proc to Generate a list of C# constants representing data field names.

Doblar comillas simples (escapar para Oracle y Sybase)

SELECT with conditional WHERE parts

HABTM relationship MySQL tables for use in Rails

PHP - Limpiar inyección sql

Count amout of nodeviews in a year

Remove all tables from a database

Date au format XL

Selection en fonction de la date

CSS / SQL / .NET menu bar

Get HTML list of Array Keys

Database access - table creation

now plus 20 years

SELECT older than x days

Get the Return Value from an SQL Stored Procedure

Created Date & Last Modified Date Triggers

Script to Create a Script Granting EXECUTE to all Stored Procs in a DB

Database Retrieve

Get the Code of a Stored Procedure as Text

Search Stored Procedure Code for a String

Anti-SQL Injection Function

Transform MM/DD/YYYY to SQL date format

Update Trigger to Increment a Version Number Column

Backwards LIKE Statements

Using a BitMask in a Where Clause

Export and import from MySQL

List all Stored Procedures in an Oracle Database

Simple Technique to Subtract Years from an Oracle Date

Import an .sql file

Add an user to an mysql account

TSQL Convert Xml DateTime (xs:datetime) to SQL DateTime

Change password for mysql root user on debian

Strip(i.e. remove) special character(s)

Generate Simple Bar Charts From a MySQL Prompt

MySQL Mass Text/String Replace

Reset auto increment on a table

Add Column After Another Column SQL

Ordering multiple SELECT statements in a UNION

MySQL LOAD DATA INFILE with WHERE

clean user input data ( GET, POST, COOKIE )

Ruby One-liner for Restoring One Table from a Huge SQL Dump

Prevent SQL Injection

Enum to Array / SQL to PHP

blahh

Load CSV file to SQL DB

Move inactive Joomla 1.0 modules to the bottom of the modules list

Add a Constant Value to a RecordSet

Get Columns and Comments (Oracle)

Get a list of all the user tables (Oracle)

Generate the SQL necessary to create sequences for every table (Oracle)

Generate the SQL necessary to create triggers (Oracle)

Copy table into a new table

Differences between two Tables

See all mysql grants

Date 0000-00-00

String Validation for Sqlinjection

MySQL based functions

Create a CSV File From Query Results

Rendering Query Results in Vertical Format

TSQL to Reset a Tables Primary Key Autonumber

Update from select

SoftPRO Data Collector

GUI Collector - Main

GUI Collector - SoftPRO Library

PHP escape for SQL

TSQL to Concatenate Subquery Row Values into a Column Value

SQL To Show WaitTime and other Process Stats

Utility PHP function to paginate SQL queries

MySQL Commands I wish I could remember

TSQL for Recursive Select Using Common Table Expressions

ASP.Net Page to Return an Image from an SQL Blob Query