advanced search

rengber

Member since 07/25/2006

Location: New Zealand

Website: http://rengberg.blogspot.com/

15 snippets

View their favorites


Their Tags


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.

rengber's Recent SQL Snippets

« Prev [Page 1 of 1] Next »

  1. [ ]TSQL for Recursive Select Using Common Table Expressions

    SQL sql tsql recursive CTE
    posted on March 24, 2008 by rengber

  2. [ ]SQL To Show WaitTime and other Process Stats

    SQL sql performance Troubleshooting Diagnostics saved by 1 person
    posted on March 19, 2008 by rengber

  3. [ ]TSQL to Concatenate Subquery Row Values into a Column Value

    SQL sql StringHandling Subquery
    posted on March 19, 2008 by rengber

  4. [ ]TSQL to Reset a Tables Primary Key Autonumber

    SQL database sql tip DDL
    posted on February 17, 2008 by rengber

  5. [ ]Add a Constant Value to a RecordSet

    SQL sql
    posted on January 20, 2008 by rengber

  6. [ ]TSQL Convert Xml DateTime (xs:datetime) to SQL DateTime

    SQL tsql xml DateTime conversion
    posted on October 3, 2007 by rengber

  7. [ ]Simple Technique to Subtract Years from an Oracle Date

    SQL Oracle PLSQL DateTime
    posted on September 25, 2007 by rengber

  8. [ ]List all Stored Procedures in an Oracle Database

    SQL database sql Oracle StoredProc DBA PSQL
    posted on September 24, 2007 by rengber

  9. [ ]Using a BitMask in a Where Clause

    SQL sql tsql bitwise BitMask
    posted on September 9, 2007 by rengber

  10. [ ]Update Trigger to Increment a Version Number Column

    SQL database tsql trigger Technique
    posted on August 7, 2007 by rengber

  11. [ ]Search Stored Procedure Code for a String

    SQL sql tsql
    posted on May 15, 2007 by rengber

  12. [ ]Get the Code of a Stored Procedure as Text

    SQL sql
    posted on May 15, 2007 by rengber

  13. [ ]Script to Create a Script Granting EXECUTE to all Stored Procs in a DB

    SQL sql script security
    posted on May 6, 2007 by rengber

  14. [ ]Oracle DateTime Interval

    SQL Oracle PLSQL DateTime
    posted on July 30, 2006 by rengber

  15. [ ]Oracle Stored Proc to Return a Recordset (Oracle Side)

    SQL Oracle PLSQL StoredProc
    posted on July 25, 2006 by rengber
« Prev [Page 1 of 1] Next »