• code snippets
  • all code snippets/
  • popular code snippets/
  • your code snippets
• extras
• blog
• about snipplr

• Big /
• Small

Top Users

•  chrisaiv (285)
•  jerryvig (264)
•  girliegeek (213)
•  scott2b (208)
•  noah (207)
•  narkisr (188)
•  ljayz (185)
•  adrianparr (180)
•  1man (166)
•  Scooter (158)

Popular Tags

Popular SQL Snippets Tagged 'sql'

• All time
•  / week
•  / month
•  / year

• All / 
• JavaScript / 
• HTML / 
• PHP / 
• CSS / 
• Ruby / 
• Objective C

1. MySQL Commands I wish I could remember

   SQL mysql sql saved by 20 people
   posted on March 23, 2008 by chrisaiv

2. Load CSV into MySQL

   SQL mysql sql csv saved by 13 people
   posted on August 12, 2006 by brentroady

3. Update from select

   SQL select sql update saved by 8 people
   posted on February 21, 2008 by wolfie

4. SQL - Find and Replace

   SQL sql replace find and saved by 5 people
   posted on October 8, 2010 by jamiebrwr

5. Find Stored Procedures with specified name or contains specified text

   SQL sql search saved by 4 people
   posted on August 5, 2010 by lance

6. Find string anywhere in Sql Database

   SQL sql String all find columns saved by 4 people
   posted on August 2, 2010 by emregulcan

7. Timezone database

   SQL sql timezone saved by 4 people
   posted on July 23, 2010 by emregulcan

8. Calculating distance in Kilometres and Miles from Latitude and Longitude

   SQL mysql sql math longitude distance latitude postcode saved by 4 people
   posted on December 1, 2009 by zingo

9. Drop all connections to a sql 2005 database

   SQL sql sql2005 saved by 3 people
   posted on September 22, 2010 by samwa

10. only select date part from datetime

    SQL sql date simple part saved by 3 people
    posted on August 31, 2010 by g8rpal

11. Display Missing Indexes of the Current DB ordered by Index Advantage

    SQL sql DMV saved by 3 people
    posted on April 12, 2010 by tvanzele

12. Finding duplicates with SQL

    SQL sql count find duplicates saved by 3 people
    posted on February 25, 2010 by jmiller

13. Search Database for string

    SQL sql search mssql tsql String for Microsoft saved by 3 people
    posted on December 31, 2009 by CDIDevs

14. Create a Temporary table within a SQL Stored Procedure

    SQL sql table sproc stored procedure temp queries Mulitple saved by 3 people
    posted on November 6, 2009 by highlyevolved

15. Grant MySQL Privileges

    SQL mysql sql textmate privileges grant saved by 3 people
    posted on April 4, 2008 by cbrant

16. Differences between two Tables

    SQL mysql sql diff saved by 3 people
    posted on February 1, 2008 by zingo

17. Load CSV file to SQL DB

    SQL sql csv saved by 3 people
    posted on January 11, 2008 by Abe

18. MySQL error reporting

    SQL mysql database sql php error code report saved by 3 people
    posted on November 24, 2006 by Shpigford

19. Sql Date Difference

    SQL sql date difference saved by 2 people
    posted on January 7, 2012 by jsturtevant

20. Auto Incremementing Id for Insert in T-SQL table

    SQL sql saved by 2 people
    posted on December 20, 2011 by ezerick

21. Find duplicate entries

    SQL sql saved by 2 people
    posted on November 14, 2011 by Neven

22. SQL SERVER – Useful DateTime Functions to Find Specific Dates

    SQL sql server functions to DateTime find dates useful specific saved by 2 people
    posted on April 14, 2011 by kashif21

23. Set Drupal site online

    SQL sql drupal Online saved by 2 people
    posted on December 3, 2010 by titosemi

24. Set Drupal site offline

    SQL sql drupal offline saved by 2 people
    posted on December 3, 2010 by titosemi

25. Find and Replace in SQLite

    SQL database sql db replace find-and-replace SQLite saved by 2 people
    posted on September 26, 2010 by traeregan

26. sql filter column by csv string

    SQL sql saved by 2 people
    posted on September 22, 2010 by samwa

27. Search stored procedures

    SQL sql saved by 2 people
    posted on September 22, 2010 by samwa

28. Get record count for a specific database

    SQL sql saved by 2 people
    posted on August 14, 2010 by edwinet

29. Clean SQL Injection from your tables

    SQL sql script injection update saved by 2 people
    posted on June 29, 2010 by emregulcan

30. Clean Injection from Database Tables

    SQL database sql search script replace injection find saved by 2 people
    posted on June 15, 2010 by emregulcan

31. Find tables without a clustered index

    SQL sql index DMV saved by 2 people
    posted on April 1, 2010 by tvanzele

32. Index fragmentation in all db's per instance

    SQL sql DMV saved by 2 people
    posted on March 31, 2010 by tvanzele

33. TSQL - Find All Empty Columns in a Database

    SQL sql tsql empty all find columns saved by 2 people
    posted on March 26, 2010 by ezerick

34. Find table by column name

    SQL sql search name Oracle field column saved by 2 people
    posted on February 24, 2010 by andreiabohner

35. Re-seed Identity Table

    SQL sql seed identity reseed saved by 2 people
    posted on December 31, 2009 by CDIDevs

36. Convert Date/Time in SQL

    SQL sql time date DateTime convert saved by 2 people
    posted on November 4, 2009 by highlyevolved

37. Delete All Foreign Keys

    SQL sql admin saved by 2 people
    posted on October 26, 2009 by marcocs

38. Foreign Keys & DB Design

    SQL sql key Foreign saved by 2 people
    posted on July 7, 2009 by iloveitaly

39. Move inactive Joomla 1.0 modules to the bottom of the modules list

    SQL sql MODULES update joomla10 saved by 2 people
    posted on January 16, 2008 by torkil

40. Get first day of month using datediff

    SQL sql saved by 1 person
    posted on November 16, 2012 by snoopmole