Advanced Search

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged sql

1 2 3 4 5 6 7 ... 12
Drop store procedures
0 1694 posted 12 years ago by ironcrema
Función sql que devuelve una tabla. parametros ID, cadena, caracter_slit
0 1781 posted 12 years ago by ironcrema
Example: CREATE SCHEMA `db_wordpress_02` ; GRANT ALL PRIVILEGES ON db_wordpress_02.* to 'root'@'localhost' IDENTIFIED BY 'scr1ptlov3r';
1 1678 posted 12 years ago by ampt
Extrae subcadena de cadena separado por caracter
0 1506 posted 12 years ago by ironcrema
Agrega Llave Foránea
0 1431 posted 12 years ago by ironcrema
How to get a query based on case/when sintax, on WHERE statement (Treated as boolean expresion)
0 1327 posted 12 years ago by keidash
using this code in a stored procedure you can reset the seed of the identity column in sql server database
0 1649 posted 12 years ago by PalCoder
This SQL would help you to transpose a rows into columns in SQL
0 3213 posted 12 years ago by mprabhuram
How to get onlye the time in SQL
0 1494 posted 13 years ago by keidash
Bulk upload a CSV into Microsoft SQL Server
0 1735 posted 13 years ago by dego89
This SQL statesment help you to understand which trigger is going to execute first and which one is going to execute last.
0 1846 posted 13 years ago by edwinet
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 6407 posted 13 years ago by decahedronhotmailcom
Run these queries (phpMyAdmin will do) to delete all media in the library, and remove all post attachment affiliation
1 3960 posted 13 years ago by rickygri
http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
0 1487 posted 13 years ago by hairajeshk
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 1957 posted 13 years ago by edwinet
It removes relations before deleting tables.
0 1524 posted 13 years ago by fixpq
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 1098 posted 13 years ago by colonia
One line to determine start of previous month
1 1609 posted 13 years ago by snoopmole
ver tablas que tiene un usario asiganadas por privilegio
0 5681 posted 13 years ago by thescorpion
Uso de Grant y Revoke de objetos masivos de distintos user
0 1475 posted 13 years ago by thescorpion
http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/
0 1421 posted 13 years ago by BrentS
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 1442 posted 13 years ago by thescorpion
Delete a defined number of rows from a db2 database table
0 1538 posted 13 years ago by claudiodev
Mostrar Objetos que hacen Referencia a un Objeto Especifico en Oracle
0 1673 posted 13 years ago by thescorpion
SQL Server 2008 Date/Time Statements
0 1199 posted 13 years ago by msstar
Consular los tablespace y mostrar su tamaño , uso y espacio libre en Megabyte
0 5897 posted 13 years ago by thescorpion
SQL update examples using joins
1 1689 posted 13 years ago by ed_trench
Borrar archivos Log con Rman
0 2237 posted 13 years ago by thescorpion
find what profile values are set for a particular user
0 1598 posted 13 years ago by theonlyalterego
Input: Month and year number Output: Last day of month
0 1396 posted 13 years ago by sjmoorecouk
1 2 3 4 5 6 7 ... 12