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 array c forms

Welcome To Snipplr

Everyone's Recent SQL Snippets

« Prev 1 ... 8 9 10 11 12 ... 18 Next »

SQL Change password to an user in MySQL

Only works if you have the mysql-root password

mysql

0 1646 posted 15 years ago by isholgueras

SQL mysql dump single table

Backup a single table from a database

mysql
table

0 1589 posted 15 years ago by tribal

SQL Oracle Applications - Find Application (Module) Long Name from Short name

use this SQL query to find out an applications full name (aka long name) and/or application id based on the application short name. This can obviously be re-written to perform the reverse.

Oracle

0 2758 posted 15 years ago by theonlyalterego

SQL Split table MySQL

0 1142 posted 15 years ago by JohnnyGamba

SQL Actualizar, Eliminar llaves primarias de una tabla y sus tablas hijas

0 1463 posted 15 years ago by JohnnyGamba

SQL View active sessions in Oracle

Oracle

0 1527 posted 15 years ago by xavsio4

SQL Agreagar 0 a la izquierda de un numero o fecha. Padleft

date
sql

0 1772 posted 15 years ago by ramirocalero

SQL Remove trailing newlines from database fields

sometimes we botch an import, and end up with return or newline characters in the field. So fields which should be empty have \r in them, or fields with text data have an invisible trailing newline. This makes it impossible to match the text values....

mysql

0 1767 posted 15 years ago by powerthru

SQL Updating guid for posts and pages in Wordpress database

1 2808 posted 15 years ago by arnach

SQL Check Server Property

1 1336 posted 15 years ago by okepaing

SQL To sort varchar fields which contain numeric data

To sort varchar fields which contain numeric data & returning XML

0 1385 posted 15 years ago by aunlead

SQL SQL - Find and Replace

3 2102 posted 15 years ago by jamiebrwr

SQL Solucion al error cuando creamos diagramas de base de datos despues de mudar una BD

Solucion a error cuando mudamos una bd de una pc a otra y luego no podemos crear un diagrama de la BD

2 2272 posted 15 years ago by derebus

SQL WP Revisions Clean

wordpress

0 1166 posted 15 years ago by theasta

SQL List all columns in server

list

2 2026 posted 15 years ago by g8rpal

SQL Select Duplicates

mysql
sql

1 1478 posted 15 years ago by traeregan

SQL Find and Replace in SQLite

1 2171 posted 15 years ago by traeregan

SQL Select Records Beginning With Certain Letter

1 1526 posted 15 years ago by traeregan

SQL sql filter column by csv string

2 1704 posted 15 years ago by samwa

SQL Search stored procedures

2 1478 posted 15 years ago by samwa

SQL Drop all connections to a sql 2005 database

2 2193 posted 15 years ago by samwa

SQL Search & Replace in SQL

1 1688 posted 15 years ago by crs

SQL Check temporary table exists

Verify whether temporary table created is exists or not

table

1 1849 posted 15 years ago by hairajeshk

SQL Find Column Name in all tables in a Database

Find column name in all tables of a database

2 2450 posted 15 years ago by hairajeshk

SQL Pasar data de una tabla a otra

Declaramos tantas variables como campos vaya a devolver la select que nos estamos currando para el cursor, en este ejemplo con dos campos vamos contentos: * declare @campo1 int * declare @campo2 int Ahora declaramos el cursor, al cual...

data

0 1889 posted 15 years ago by derebus

SQL Autogenerate identity column via Select

function

1 1507 posted 15 years ago by g8rpal

SQL Cursor FOR LOOP

You would use a CURSOR FOR Loop when you want to fetch and process every record in a cursor. The CURSOR FOR Loop will terminate when all of the records in the cursor have been fetched.

Oracle

1 1670 posted 15 years ago by mprabhuram

SQL Script all Foreign Key Constraints - Result Set can be used to DROP constraints for 'TableName'

1 1747 posted 15 years ago by g8rpal

SQL Script all Foreign Key Constraints - Result Set can be used to copy constraints to your testing DB or to keep on hand in case of

1 3231 posted 15 years ago by g8rpal

SQL SQL SERVER â€“ 2005 â€“ Find Tables With Foreign Key Constraint in Database

1 2288 posted 15 years ago by g8rpal