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

« Prev 1 ... 4 5 6 7 8 ... 18 Next »

SQL Bulk insert/upload microsoft sql server (csv)

Bulk upload a CSV into Microsoft SQL Server

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

query
sql

0 968 posted 11 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 4756 posted 11 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 2650 posted 11 years ago by rickygri

SQL PostgreSQL wildcard search for any of a list of words

PostgreSQL wildcard search for any of a list of words, returns true or false depending on whether its pattern matches the given string.

query

0 1084 posted 11 years ago by alecolucci

SQL Visual Representation of SQL Joins

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

0 804 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 (...

0 1089 posted 11 years ago by edwinet

SQL Delete all tables from SQL

It removes relations before deleting tables.

0 797 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...

0 541 posted 12 years ago by colonia

SQL Get first day of month using datediff

One line to determine start of previous month

1 828 posted 12 years ago by snoopmole

SQL Ver tablas asignadas a un usuario por privilegios

ver tablas que tiene un usario asiganadas por privilegio

Oracle
sql

0 4212 posted 12 years ago by thescorpion

SQL Grant y Revoke sobre objetos - dinamico

Uso de Grant y Revoke de objetos masivos de distintos user

Oracle
sql

0 770 posted 12 years ago by thescorpion

SQL Microsoft SQL Server: Back up all transaction logs.

Backs up all database transaction logs within a Microsoft SQL Server instance except for databases set to simple recovery mode.

backup

1 824 posted 12 years ago by jprochazka

SQL Microsoft SQL Server: Back up all databases.

Backs up all databases contained in a Microsoft SQL Server instance.

backup

1 803 posted 12 years ago by jprochazka

SQL Rename Column Name

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

0 715 posted 12 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...

Oracle
sql

0 719 posted 12 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 826 posted 12 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

Oracle
sql

0 977 posted 12 years ago by thescorpion

SQL SQL Date/Time Statements

SQL Server 2008 Date/Time Statements

0 632 posted 12 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 4979 posted 12 years ago by thescorpion

SQL SQL UPDATE using JOIN

SQL update examples using joins

sql
update

1 823 posted 12 years ago by ed_trench

SQL Borra archivos LOG Oracle usando RMAN

Borrar archivos Log con Rman

Oracle
sql

0 1478 posted 12 years ago by thescorpion

SQL Oracle Find Profile Values for User

find what profile values are set for a particular user

Oracle
sql

0 879 posted 12 years ago by theonlyalterego

SQL Return last day of month

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

server
sql

0 747 posted 12 years ago by sjmoorecouk

SQL Backup Export MySQL Database using mysqldump and compress gzip it

Backup/Export MySQL Database using mysqldump and compress/gzip it ------------------------------------------

backup
mysql

0 1050 posted 12 years ago by MohamedAlaa

SQL Import MySQL Dumpfile, SQL Datafile Into My Database

Run This Command in your Terminal ---------------------------------------- mysql -u **username** -p -h localhost **DATA-BASE-NAME** < data.sql

file
mysql

0 890 posted 12 years ago by MohamedAlaa

SQL SQL - SQL Server - Add Column with Default Value and Check Constraint

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 1130 posted 12 years ago by denakitan

SQL Search DDL (stored procedures, functions, etc) for keywords

Search SQL Server or Oracle database for keyword embedded within stored procedures, functions, triggers, etc.

0 876 posted 12 years ago by jstrawther

SQL sql_FindingDupValues

Can be used when looking for values that are duplicates.

0 664 posted 12 years ago by BrentS

SQL Manual activation of a module in Joomla!

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)

mysql
sql

0 811 posted 12 years ago by iroybot