Login / Register

Share Snipplr

Follow @Snipplr

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

sql

0 577 posted 10 years ago by ironcrema

SQL Split SQL Server

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

sql

0 617 posted 10 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';

sql

1 674 posted 10 years ago by ampt

SQL Extraer cadena segun caracter

Extrae subcadena de cadena separado por caracter

sql

0 557 posted 10 years ago by ironcrema

SQL Agregar LLave ForÃ¡nea

Agrega Llave ForÃ¡nea

sql

0 510 posted 10 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)

sql

0 472 posted 10 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

sql

0 593 posted 10 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

sql

0 2006 posted 10 years ago by mprabhuram

SQL Get Only Time in SQL

How to get onlye the time in SQL

sql

0 553 posted 10 years ago by keidash

SQL Bulk insert/upload microsoft sql server (csv)

Bulk upload a CSV into Microsoft SQL Server

sql

0 632 posted 10 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.

sql

0 701 posted 10 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

sql

0 4165 posted 10 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

sql

1 2270 posted 11 years ago by rickygri

SQL Visual Representation of SQL Joins

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

sql

0 564 posted 11 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 (...

sql

0 803 posted 11 years ago by edwinet

SQL Delete all tables from SQL

It removes relations before deleting tables.

sql

0 576 posted 11 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...

sql

0 370 posted 11 years ago by colonia

SQL Get first day of month using datediff

One line to determine start of previous month

sql

1 604 posted 11 years ago by snoopmole

SQL Ver tablas asignadas a un usuario por privilegios

ver tablas que tiene un usario asiganadas por privilegio

sql

0 3189 posted 11 years ago by thescorpion

SQL Grant y Revoke sobre objetos - dinamico

Uso de Grant y Revoke de objetos masivos de distintos user

sql

0 523 posted 11 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/

sql

0 519 posted 11 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...

sql

0 494 posted 11 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

sql

0 587 posted 11 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

sql

0 721 posted 11 years ago by thescorpion

SQL SQL Date/Time Statements

SQL Server 2008 Date/Time Statements

sql

0 438 posted 11 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

sql

0 4668 posted 11 years ago by thescorpion

SQL SQL UPDATE using JOIN

SQL update examples using joins

sql

1 610 posted 11 years ago by ed_trench

SQL Borra archivos LOG Oracle usando RMAN

Borrar archivos Log con Rman

sql

0 1169 posted 11 years ago by thescorpion

SQL Oracle Find Profile Values for User

find what profile values are set for a particular user

sql

0 622 posted 11 years ago by theonlyalterego

SQL Return last day of month

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

sql

0 526 posted 11 years ago by sjmoorecouk

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