Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

sql page server Oracle mysql csv database wordpress error php code drupal date replace script security search xml function text order textmate update file query data list table excel backup customer load login ASP codeigniter magento simple user windows convert joomla math find copy json Business directory number path images Online log links template link Development api twitter best web format object cache mail email html javascript actionscript apache color download service android animation browser aspnet ajax

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged sql

« Prev 1 2 3 4 5 6 7 ... 12 Next »

SQL Drop store procedures by name contains

Drop store procedures

0 1298 posted 11 years ago by ironcrema

SQL Split SQL Server

FunciÃ³n sql que devuelve una tabla. parametros ID, cadena, caracter_slit

0 1407 posted 11 years ago by ironcrema

SQL Create DB for Wordpress

Example: CREATE SCHEMA `db_wordpress_02` ; GRANT ALL PRIVILEGES ON db_wordpress_02.* to 'root'@'localhost' IDENTIFIED BY 'scr1ptlov3r';

1 1286 posted 11 years ago by ampt

SQL Extraer cadena segun caracter

Extrae subcadena de cadena separado por caracter

0 1182 posted 11 years ago by ironcrema

SQL Agregar LLave ForÃ¡nea

Agrega Llave ForÃ¡nea

0 1095 posted 12 years ago by ironcrema

SQL CASE IN WHERE SENTENCE

How to get a query based on case/when sintax, on WHERE statement (Treated as boolean expresion)

0 1000 posted 12 years ago by keidash

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

using this code in a stored procedure you can reset the seed of the identity column in sql server database

0 1293 posted 12 years ago by PalCoder

SQL CASE statement to transpose rows in to columns

This SQL would help you to transpose a rows into columns in SQL

0 2792 posted 12 years ago by mprabhuram

SQL Get Only Time in SQL

How to get onlye the time in SQL

0 1154 posted 12 years ago by keidash

SQL Bulk insert/upload microsoft sql server (csv)

Bulk upload a CSV into Microsoft SQL Server

0 1343 posted 12 years ago by dego89

SQL Viewing Trigger Order (First and Last)

This SQL statesment help you to understand which trigger is going to execute first and which one is going to execute last.

0 1354 posted 12 years ago by edwinet

SQL sql time zone table by country/city

Sql table with country codes coordinates timezone utc utc-dst usefull if you want to have human friendly time zones like America/Los_Angeles

0 5569 posted 12 years ago by decahedronhotmailcom

SQL SQL query to delete all media and attachments in wordpress

Run these queries (phpMyAdmin will do) to delete all media in the library, and remove all post attachment affiliation

1 3312 posted 12 years ago by rickygri

SQL Visual Representation of SQL Joins

http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

0 1140 posted 12 years ago by hairajeshk

SQL Auditing SQL Server User and Role Permissions for Databases

The sysprotects system table reports all of the permissions granted or denied in a given database. We'll need to join it with sysusers and sysobjects to get all the information we need. Here's an example query that only pulls information on objects (...

0 1480 posted 12 years ago by edwinet

SQL Delete all tables from SQL

It removes relations before deleting tables.

0 1160 posted 12 years ago by fixpq

SQL Implementando Database Mirror

OlÃ¡ Pessoal, Neste artigo vou falar sobre Database Mirror, uma nova funcionalidade do SQL Server 2005 para alta disponibilidade.Database Mirror consiste em basicamente um espelhamento de um banco de dados, uma soluÃ§Ã£o que fornece quase em tempo r...

0 821 posted 12 years ago by colonia

SQL Get first day of month using datediff

One line to determine start of previous month

1 1255 posted 12 years ago by snoopmole

SQL Ver tablas asignadas a un usuario por privilegios

ver tablas que tiene un usario asiganadas por privilegio

0 5175 posted 12 years ago by thescorpion

SQL Grant y Revoke sobre objetos - dinamico

Uso de Grant y Revoke de objetos masivos de distintos user

0 1136 posted 12 years ago by thescorpion

SQL Rename Column Name

http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/

0 1073 posted 13 years ago by BrentS

SQL Creacion de DBLINK con Full name service

Cuando se da el caso que tienes 2 servidores diferentes y el ServiceName de oracle es el mismo...En el momento de crear un dblink hay que especificar bien la cadena de coneccion para que se direccione al otro servidor y no escoja el serviceName del e...

0 1102 posted 13 years ago by thescorpion

SQL Delete a limited set of rows in a DB2 database

Delete a defined number of rows from a db2 database table

0 1167 posted 13 years ago by claudiodev

SQL Mostrar Objetos que hacen Referencia a un Objeto Especifico

Mostrar Objetos que hacen Referencia a un Objeto Especifico en Oracle

0 1327 posted 13 years ago by thescorpion

SQL SQL Date/Time Statements

SQL Server 2008 Date/Time Statements

0 904 posted 13 years ago by msstar

SQL Consultar el MB los tamaÃ±os y porcentaje libre de TableSpace Oracle

Consular los tablespace y mostrar su tamaÃ±o , uso y espacio libre en Megabyte

0 5466 posted 13 years ago by thescorpion

SQL SQL UPDATE using JOIN

SQL update examples using joins

1 1299 posted 13 years ago by ed_trench

SQL Borra archivos LOG Oracle usando RMAN

Borrar archivos Log con Rman

0 1899 posted 13 years ago by thescorpion

SQL Oracle Find Profile Values for User

find what profile values are set for a particular user

0 1263 posted 13 years ago by theonlyalterego

SQL Return last day of month

Input: Month and year number Output: Last day of month

0 1091 posted 13 years ago by sjmoorecouk