sql codes

Copy an SQL Table

Import MySQL Dumpfile, SQL Datafile Into My Database

Backup Export MySQL Database using mysqldump and compress gzip it

Prevent sql injection in LIKE queries

Return last day of month

Oracle Find Profile Values for User

Borra archivos LOG Oracle usando RMAN

SQL UPDATE using JOIN

Consultar el MB los tamaños y porcentaje libre de TableSpace Oracle

SQL Date/Time Statements

Mostrar Objetos que hacen Referencia a un Objeto Especifico

Delete a limited set of rows in a DB2 database

Creacion de DBLINK con Full name service

create new database

Rename Column Name

Microsoft SQL Server: Back up all databases.

Microsoft SQL Server: Back up all transaction logs.

Grant y Revoke sobre objetos - dinamico

Ver tablas asignadas a un usuario por privilegios

What MySQL Table Has What Column

Get first day of month using datediff

VB.NET Method Perform Scalar

Implementando Database Mirror

Delete all tables from SQL

Auditing SQL Server User and Role Permissions for Databases

Visual Representation of SQL Joins

Selecting a Random Row from Table in MySQL

PostgreSQL wildcard search for any of a list of words

SQL query to delete all media and attachments in wordpress

Connecting to Oracle using Java JDBC

sql time zone table by country/city

Viewing Trigger Order (First and Last)

Bulk insert/upload microsoft sql server (csv)

Get Only Time in SQL

CASE statement to transpose rows in to columns

Reseting the seed of column identity in sql sever using stored procedures

Update trigger for datetime modified field

CASE IN WHERE SENTENCE

Change user password in mySQL

List locked object Oracle Database

Search in Tags Set in MySQL

Sublime Snippet: dbNumRows

Agregar LLave Foránea

Extraer cadena segun caracter

Create DB for Wordpress

Split SQL Server

Adding Linked Server to MSSQL

Drop store procedures by name contains

Parse xml in SQL

Create Table Based on Another Table

New SQL Record = Populate TimeStamp Field with GetDate() Function

SQL Server Data Types

Search for text in all db objects in database

Calculate Relative Time Ago

A light implementation of Session table in Mysql 5.6 using memory engine

webEdition-Objekt mit php erstellen

Table creating sql for a typical shopping cart

Find a blocking session and kill it

Search column names in databasee

jQuery UI autocomplete mit JSON und externer php-Seite als Quelle

Jacaard Index, Similarity based on Tag System

Get all procedures from Oracle packages

VB.NET SQL Example: How to send SMS in VB.NET using SQL database

PHP - Doctrine - Left join ON condition AND other condition syntax in Doctrine

Migrate a Wordpress

Generate SQL query for column matching

Find last two updates to a record

mysql sequence generator ( decimal definition )

mysql calendar table

mysql batch sql statements

mysql tablename search information schema

mysql unroll variable length string list

mysql clone table with structure and indexes

mysql rank with ties

mysql procedure throw_error

mysql pivot data

Get rows coutn of all datatables of one database

Procedimiento almacenado devuelve todos los registros si no recibe parametros

Formatos de datos en SQL

Funcion conectar a BD SQL Server (sqlconection)

Insert bloqueando la tabla

SQL Server query sample using rank/dense_rank

Show the output of a query in a more readable vertical format

SQL Server día a día

mysql subquery

Oracle TO_DATE Examples

Oracle TO_CHAR Examples

Oracle CONCAT Function

Oracle NVL2 Function

Oracle LISTAGG Function with Examples

Oracle LEAST Function

Oracle GREATEST Function

Oracle REPLACE Function

Oracle CASE Expression

Oracle RTRIM Function

Oracle INSTR Function

Oracle LTRIM Function

Oracle LENGTH Function

Oracle RPAD Function