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 Tagged sql

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

SQL Wait stat list (user sessions)

1 1356 posted 16 years ago by tvanzele

SQL Percentage of IO for each database and per driveletter

0 1822 posted 16 years ago by tvanzele

SQL Percentage of IO for each database

0 1476 posted 16 years ago by tvanzele

SQL Open transactions with text and plans

0 1625 posted 16 years ago by tvanzele

SQL Cached Query Plans per object type

1 1465 posted 16 years ago by tvanzele

SQL Cached Query Plans

1 1400 posted 16 years ago by tvanzele

SQL Buffer pool usage per database

1 1438 posted 16 years ago by tvanzele

SQL Memory Clerks & used vas

0 1286 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

2 4351 posted 16 years ago by ezerick

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 2179 posted 16 years ago by manuelstofer

SQL Create UTF8 Database

Create a new utf8 database in MySQL

1 1613 posted 16 years ago by manuelstofer

SQL Finding duplicates with SQL

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

3 2080 posted 16 years ago by jmiller

SQL Search Stored Procedure for String

1 1449 posted 16 years ago by CDIDevs

SQL List all Stored Procs in Database

1 1942 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 1658 posted 16 years ago by CDIDevs

SQL Script table as INSERTS

1 2050 posted 16 years ago by CDIDevs

SQL Search Database for string

2 1722 posted 16 years ago by CDIDevs

SQL Search Database for Column Name

1 1606 posted 16 years ago by CDIDevs

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 2689 posted 16 years ago by zingo

SQL Joomla admin password reset

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

1 1567 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.

2 2353 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 2205 posted 16 years ago by highlyevolved

SQL Get Plesk FTP account passwords w/o logging into MySQL

0 1579 posted 16 years ago by tobewan

SQL Grab Plesk FTP account passwords

0 1534 posted 16 years ago by tobewan

SQL Delete All Foreign Keys

Delete All Foreign Keys in a database; (make sure you USE keyword)

2 1546 posted 16 years ago by marcocs

SQL Create New User and Grant

1 1640 posted 16 years ago by wearetherock

SQL TSQL Convert DateTime

I am forever forgetting this. Have to look up the 101 vs 103 in books online every time. Also forget which way around is US/NZ format. :-)

1 2339 posted 16 years ago by rengber

SQL TSQL to Get the SQL Autonumber ID of the Row Just Inserted

Dead simple, but often forgotten.

1 2044 posted 16 years ago by rengber

SQL SQL Server String Split Function

From StackOverflow. I'm still not quite happy with my understanding of it, but it looks an order of magnitude more elegant than most I've found.

0 1917 posted 17 years ago by rengber

SQL Redux Auth Table SQL

1 1731 posted 17 years ago by pdswan