PROfile

All time reputation: 143

Achievement

first submission:submitting first snipplet

rengber's Recent SQL Snippets



« Prev [Page 1 of 1] Next »
  1. FAVTSQL Convert DateTime

    SQL database sql simple conversion saved by 1 person
    posted on September 3, 2009 by rengber
  2. FAVTSQL to Get the SQL Autonumber ID of the Row Just Inserted

    SQL database sql insert db tsql query StoredProc saved by 1 person
    posted on August 31, 2009 by rengber
  3. FAVSQL Server String Split Function

    SQL database sql data tsql String recursion CTE StringParsing
    posted on July 29, 2009 by rengber
  4. FAVTSQL Function and Check Constraint to Ensure that a Parent Value is Present in the Table

    SQL database sql data tsql saved by 1 person
    posted on July 26, 2009 by rengber
  5. FAVTSQL Try Catch Error Handling

    SQL database tsql Troubleshooting ErrorHandling saved by 1 person
    posted on February 23, 2009 by rengber
  6. FAVTSQL to Start a Job Programatically

    SQL database tsql job SSIS
    posted on February 22, 2009 by rengber
  7. FAVBasic TSQL Cursor Syntax

    SQL database tsql etl cursor saved by 1 person
    posted on February 18, 2009 by rengber
  8. FAVTSQL for Recursive Select Using Common Table Expressions

    SQL sql tsql recursive CTE
    posted on March 24, 2008 by rengber
  9. FAVSQL To Show WaitTime and other Process Stats

    SQL sql performance Troubleshooting Diagnostics saved by 1 person
    posted on March 19, 2008 by rengber
  10. FAVTSQL to Concatenate Subquery Row Values into a Column Value

    SQL sql StringHandling Subquery
    posted on March 19, 2008 by rengber
  11. FAVTSQL to Reset a Tables Primary Key Autonumber

    SQL database sql tip DDL
    posted on February 17, 2008 by rengber
  12. FAVAdd a Constant Value to a RecordSet

    SQL sql
    posted on January 20, 2008 by rengber
  13. FAVTSQL Convert Xml DateTime (xs:datetime) to SQL DateTime

    SQL tsql xml DateTime conversion
    posted on October 3, 2007 by rengber
  14. FAVSimple Technique to Subtract Years from an Oracle Date

    SQL Oracle PLSQL DateTime
    posted on September 25, 2007 by rengber
  15. FAVList all Stored Procedures in an Oracle Database

    SQL database sql Oracle StoredProc DBA PSQL
    posted on September 24, 2007 by rengber
  16. FAVUsing a BitMask in a Where Clause

    SQL sql tsql bitwise BitMask
    posted on September 9, 2007 by rengber
  17. FAVUpdate Trigger to Increment a Version Number Column

    SQL database tsql trigger Technique
    posted on August 7, 2007 by rengber
  18. FAVSearch Stored Procedure Code for a String

    SQL sql tsql
    posted on May 15, 2007 by rengber
  19. FAVGet the Code of a Stored Procedure as Text

    SQL sql
    posted on May 15, 2007 by rengber
  20. FAVScript to Create a Script Granting EXECUTE to all Stored Procs in a DB

    SQL sql script security
    posted on May 6, 2007 by rengber
  21. FAVOracle DateTime Interval

    SQL Oracle PLSQL DateTime
    posted on July 30, 2006 by rengber
  22. FAVOracle 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 »