Welcome To Snipplr
Everyone's Recent SQL Snippets Tagged sql
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
Función sql que devuelve una tabla. parametros ID, cadena, caracter_slit
0
617
posted 10 years ago by ironcrema
Example:
CREATE SCHEMA `db_wordpress_02` ;
GRANT ALL PRIVILEGES ON db_wordpress_02.* to 'root'@'localhost' IDENTIFIED BY 'scr1ptlov3r';
1
674
posted 10 years ago by ampt
How to get a query based on case/when sintax, on WHERE statement (Treated as boolean expresion)
0
472
posted 10 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
593
posted 10 years ago by PalCoder
This SQL would help you to transpose a rows into columns in SQL
0
2006
posted 10 years ago by mprabhuram
This SQL statesment help you to understand which trigger is going to execute first and which one is going to execute last.
0
701
posted 10 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
4165
posted 10 years ago by decahedronhotmailcom
Run these queries (phpMyAdmin will do) to delete all media in the library, and remove all post attachment affiliation
1
2270
posted 11 years ago by rickygri
http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
0
564
posted 11 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
803
posted 11 years ago by edwinet
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
370
posted 11 years ago by colonia
http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/
0
519
posted 11 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
494
posted 11 years ago by thescorpion
Mostrar Objetos que hacen Referencia a un Objeto Especifico en Oracle
0
721
posted 11 years ago by thescorpion
Consular los tablespace y mostrar su tamaño , uso y espacio libre en Megabyte
0
4668
posted 11 years ago by thescorpion