advanced code snippet search

login / Register

We Recommend

SQL Cookbook SQL Cookbook
Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.

Share Snipplr

del.icio.us Digg Furl Reddit

Plugins

Popular Tags

BitMask CTE DDL DateTime Diagnostics Oracle PLSQL PSQL Shell StoredProc String Subquery Technique UNION add administration adminitration auto basedatos bitwise cli coalesce code column commands console count country created csv currency cursor data database date db db2 debian debugging diff drupal dump duplicate error espaa file fulltext function geonames id insert java joomla last list login maintainance mssql mysql nodes optmize order paginate password performance php postgres primary privileges procedure query random recursive replace root script search select server sorting sp special sproc sql statistics stats stored syntax table timestamp tip trigger tsql update us users wordpress xml

Everyone's Recent SQL Snippets

« Prev [Page 3 of 7] Next »

  1. [ ]Get a list of all the user tables (Oracle)

    SQL sql Oracle
    posted on January 23, 2008 by thecrumb

  2. [ ]Get Columns and Comments (Oracle)

    SQL sql Oracle
    posted on January 23, 2008 by thecrumb

  3. [ ]Add a Constant Value to a RecordSet

    SQL sql
    posted on January 20, 2008 by rengber

  4. [ ]Move inactive Joomla 1.0 modules to the bottom of the modules list

    SQL sql MODULES update joomla saved by 1 person
    posted on January 16, 2008 by torkil

  5. [ ]MySQL search

    SQL mysql search saved by 7 people
    posted on January 13, 2008 by j_junyent

  6. [ ]Load CSV file to SQL DB

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

  7. [ ]Table Provincias España

    SQL sql espaa saved by 1 person
    posted on January 9, 2008 by luman

  8. [ ]add plpgsql support in postgresql(Linux)

    SQL
    posted on December 4, 2007 by arunpjohny

  9. [ ]Check/Reset Identity MS-SQL

    SQL identity saved by 1 person
    posted on December 3, 2007 by mafro

  10. [ ]Update Select

    SQL update saved by 3 people
    posted on November 23, 2007 by mafro

  11. [ ]MYSQL add column to excisting table

    SQL mysql column saved by 1 person
    posted on November 23, 2007 by Tamedo

  12. [ ]Restore postgres backup file(dumpall)

    SQL postgres
    posted on November 19, 2007 by arunpjohny

  13. [ ]Posgres backups in linux

    SQL postgres
    posted on November 19, 2007 by arunpjohny

  14. [ ]MySQL LOAD DATA INFILE with WHERE

    SQL mysql database textmate saved by 1 person
    posted on November 15, 2007 by bassnode

  15. [ ]Ordering multiple SELECT statements in a UNION

    SQL mysql database select sql order UNION BY ordering
    posted on November 6, 2007 by andyhartleeds

  16. [ ]Add Column After Another Column SQL

    SQL add column order
    posted on October 24, 2007 by iloveitaly

  17. [ ]Reset auto increment on a table

    SQL sql auto increment AUTOINCREMENT
    posted on October 19, 2007 by jachin

  18. [ ]MySQL Mass Text/String Replace

    SQL mysql replace String text mass saved by 2 people
    posted on October 19, 2007 by andyhartleeds

  19. [ ]Get the last date a given month

    SQL
    posted on October 19, 2007 by arunpjohny

  20. [ ]Add a interval to a given date in postgresql

    SQL postgres
    posted on October 19, 2007 by arunpjohny

  21. [ ]Generate Simple Bar Charts From a MySQL Prompt

    SQL mysql database sql cli
    posted on October 19, 2007 by zingo

  22. [ ]Get name of the weekday of a date in Postgresql

    SQL postgres
    posted on October 16, 2007 by arunpjohny

  23. [ ]Function to get year from a date in Postgresql

    SQL postgres
    posted on October 16, 2007 by arunpjohny

  24. [ ]Difference between two dates in Postgresql

    SQL postgres
    posted on October 16, 2007 by arunpjohny

  25. [ ]Strip(i.e. remove) special character(s)

    SQL character strip function remove Oracle special
    posted on October 14, 2007 by spacebar
« Prev [Page 3 of 7] Next »