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 ... 11 12 13 14 15 ... 18 Next »

SQL Percentage of IO for each database

0 1488 posted 16 years ago by tvanzele

SQL Open transactions with text and plans

0 1641 posted 16 years ago by tvanzele

SQL Cached Query Plans per object type

1 1480 posted 16 years ago by tvanzele

SQL Cached Query Plans

1 1413 posted 16 years ago by tvanzele

SQL Buffer pool usage per database

1 1451 posted 16 years ago by tvanzele

SQL Memory Clerks & used vas

0 1304 posted 16 years ago by tvanzele

SQL TSQL - Find All Empty Columns in a Database

I found this and simply want to store it. It was done by Valentino Vranken

find
sql

2 4370 posted 16 years ago by ezerick

SQL Reading XML String As Table

0 1444 posted 16 years ago by hubertd

SQL SQL: Create a user that has only access to one database

creates a user that has only access to one database, from any host

1 2206 posted 16 years ago by manuelstofer

SQL Create UTF8 Database

Create a new utf8 database in MySQL

database
sql

1 1630 posted 16 years ago by manuelstofer

SQL Finding duplicates with SQL

Here's a handy query for finding duplicates in a table.

find
sql

3 2099 posted 16 years ago by jmiller

SQL Reset Drupal admin password

drupal

1 1598 posted 16 years ago by sennesaelium

SQL move Drupal tags from one vocabulary into another

I had several vocabularies but wanted to merge them into one. A simple query does this for you. The vocabulary_id where I wanted to merge all the tags into is 3 The vocabulary_id where the tags are to be merged from is 7, 8 and 12

2 2059 posted 16 years ago by berkes

SQL Search Stored Procedure for String

1 1465 posted 16 years ago by CDIDevs

SQL Common SQL Commands (create table, etc)

update

2 1884 posted 16 years ago by CDIDevs

SQL List all Stored Procs in Database

list
sql

1 1960 posted 16 years ago by CDIDevs

SQL Re-seed Identity Table

Re-seed identity table if rows were deleted/there are gaps in numerical order

2 1676 posted 16 years ago by CDIDevs

SQL Script table as INSERTS

1 2068 posted 16 years ago by CDIDevs

SQL Search Database for string

2 1734 posted 16 years ago by CDIDevs

SQL Search Database for Column Name

1 1621 posted 16 years ago by CDIDevs

SQL Copy rows from one table to another

Just replace the squared brackets with the correct values.

copy

1 2319 posted 16 years ago by choasis

SQL Dump Table Data into CSV

mysql

2 1607 posted 16 years ago by czapata

SQL Find a Column by Name in User Tables

Perform a search of all user tables in the current database to locate a column defined in a user table that matches a certain name. The first query looks for an exact column name and the second one returns all column names which match a keyword (usi...

find
search

1 2113 posted 16 years ago by kencyber

SQL Search functions for the occurance of a string

Searches the code for all functions in the current database and returns results containing the function name, the character index where the first match was found, and a portion of the code where the match occurred.

1 1789 posted 16 years ago by kencyber

SQL Calculating distance in Kilometres and Miles from Latitude and Longitude

Using SQL you can have your database return the distance between 2 sets of Lat and Long points, and using some math functions also take into account the curvature of the earth.

3 2714 posted 16 years ago by zingo

SQL Joomla admin password reset

Reset joomla super admin password to â€adminâ€œ

joomla
sql

1 1587 posted 16 years ago by elisium

SQL Create a Temporary table within a SQL Stored Procedure

A Temp table is great for combining multiple SELECT statements in a Sproc and outputting as just one table. Don't forget to Drop the table after the SELECT * FROM #TempTableName at the end.

sql
table

2 2374 posted 16 years ago by highlyevolved

SQL Convert Date/Time in SQL

These statements convert a date/time field into just a date or a time field

2 2217 posted 16 years ago by highlyevolved

SQL Importing a MySQL database in Windows

1 2190 posted 16 years ago by Mithun

SQL Find all databases and login credentials

If you need to list all of the MySQL databases managed by Plesk along with their corresponding domains and login credentials, you can use this query:

1 1819 posted 16 years ago by tobewan