Welcome To Snipplr


Everyone's Recent SQL Snippets Tagged list



« Prev 1 Next »
  1. FAV

    List all columns in server

    SQL saved by 2 people 1 views posted 9 years ago by g8rpal
  2. FAV

    List all Stored Procs in Database

    SQL saved by 2 people 3 views posted 10 years ago by CDIDevs
  3. FAV

    Return a table list with row count

    This will return a list of all the tables in a certain database along with their row count.
    SQL saved by 2 people 2 views posted 10 years ago by blackf0rk
  4. FAV

    MySQL Table - US States

    This will create and then populate a MySQL table with a list of the names and USPS abbreviations for US states and possessions in existence.
    SQL saved by 9 people 14 views posted 11 years ago by cbrant
  5. FAV

    MySQL Table - ISO Country List with Abbreviations

    This will create and then populate a MySQL table with a list of the names and ISO 3166 codes for countries in existence.
    SQL saved by 15 people 6 views posted 11 years ago by cbrant
  6. FAV

    Comma-Delimited List using Coalesce

    If you ever need to build a comma delimited list out of a column in SQL you can easily do this using the COALESCE function.
    SQL 1 views posted 11 years ago by mcbutterbuns
« Prev 1 Next »