Advanced Search

Welcome To Snipplr

Everyone's Recent SQL Snippets

1 ... 4 5 6 7 8 ... 18
Bulk upload a CSV into Microsoft SQL Server
0 1932 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 2062 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 6707 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 4206 posted 13 years ago by rickygri
PostgreSQL wildcard search for any of a list of words, returns true or false depending on whether its pattern matches the given string.
0 2228 posted 13 years ago by alecolucci
http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
0 1656 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 2196 posted 13 years ago by edwinet
It removes relations before deleting tables.
0 1750 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 1275 posted 13 years ago by colonia
One line to determine start of previous month
1 1788 posted 13 years ago by snoopmole
ver tablas que tiene un usario asiganadas por privilegio
0 5891 posted 13 years ago by thescorpion
Uso de Grant y Revoke de objetos masivos de distintos user
0 1682 posted 13 years ago by thescorpion
Backs up all database transaction logs within a Microsoft SQL Server instance except for databases set to simple recovery mode.
1 1921 posted 13 years ago by jprochazka
Backs up all databases contained in a Microsoft SQL Server instance.
1 1945 posted 13 years ago by jprochazka
http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/
0 1635 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 1620 posted 13 years ago by thescorpion
Delete a defined number of rows from a db2 database table
0 1734 posted 13 years ago by claudiodev
Mostrar Objetos que hacen Referencia a un Objeto Especifico en Oracle
0 1851 posted 13 years ago by thescorpion
SQL Server 2008 Date/Time Statements
0 1365 posted 13 years ago by msstar
Consular los tablespace y mostrar su tamaño , uso y espacio libre en Megabyte
0 6108 posted 13 years ago by thescorpion
SQL update examples using joins
1 1893 posted 13 years ago by ed_trench
Borrar archivos Log con Rman
0 2423 posted 13 years ago by thescorpion
find what profile values are set for a particular user
0 1807 posted 14 years ago by theonlyalterego
Input: Month and year number Output: Last day of month
0 1581 posted 14 years ago by sjmoorecouk
Backup/Export MySQL Database using mysqldump and compress/gzip it ------------------------------------------
0 2426 posted 14 years ago by MohamedAlaa
Run This Command in your Terminal ---------------------------------------- mysql -u **username** -p -h localhost **DATA-BASE-NAME** < data.sql
0 1842 posted 14 years ago by MohamedAlaa
Example of SQL syntax to add a new column to an existing table, define a default value to the columns for the existing rows and also add a check constraint to limit the values that the column can hold.
0 3136 posted 14 years ago by denakitan
Search SQL Server or Oracle database for keyword embedded within stored procedures, functions, triggers, etc.
0 1681 posted 14 years ago by jstrawther
Can be used when looking for values that are duplicates.
0 1441 posted 14 years ago by BrentS
in order to avoid the .zip madness when creating a new module, you can make it available in the backend by firing a simple SQL in your DB. (mod_media is the name of the folder that holds it)
0 1824 posted 14 years ago by iroybot
1 ... 4 5 6 7 8 ... 18