rengber

Member since 07/25/2006

Location: New Zealand

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

21 snippets

4740 profile views

2 Comment(s) Posted

View their favorites

their Tags

Oracle sql script security database xml data query simple

Profile

Achievement

You have not received any achievements.

rengber's Recent SQL Snippets

All /

« Prev 1 Next »

SQL TSQL Convert DateTime

I am forever forgetting this. Have to look up the 101 vs 103 in books online every time. Also forget which way around is US/NZ format. :-)

1 784 posted 14 years ago by rengber

SQL TSQL to Get the SQL Autonumber ID of the Row Just Inserted

Dead simple, but often forgotten.

1 725 posted 14 years ago by rengber

SQL SQL Server String Split Function

From StackOverflow. I'm still not quite happy with my understanding of it, but it looks an order of magnitude more elegant than most I've found.

0 713 posted 14 years ago by rengber

SQL TSQL Try Catch Error Handling

This as it sits isn't an improvement on what happens by default. It's only useful combined with a compensating transaction or sad path in the catch block, or in allowing a loop to continue.

database

0 657 posted 15 years ago by rengber

SQL TSQL to Start a Job Programatically

database

0 607 posted 15 years ago by rengber

SQL Basic TSQL Cursor Syntax

Minimal syntax for cursor use. See URL for SQL 2005 options and improvements.

database

0 756 posted 15 years ago by rengber

SQL TSQL for Recursive Select Using Common Table Expressions

sql

0 726 posted 16 years ago by rengber

SQL SQL To Show WaitTime and other Process Stats

sql

0 591 posted 16 years ago by rengber

SQL TSQL to Concatenate Subquery Row Values into a Column Value

sql

0 797 posted 16 years ago by rengber

SQL TSQL to Reset a Tables Primary Key Autonumber

database
sql

0 587 posted 16 years ago by rengber

SQL Add a Constant Value to a RecordSet

Noob stuff, but I always end up looking this up.

sql

0 610 posted 16 years ago by rengber

SQL TSQL Convert Xml DateTime (xs:datetime) to SQL DateTime

This is as small as this can go: 'xs:dateTime(sql:variable("@stringDate"))' It needs to be a literal string for the Value() function. Xml Datatype http://msdn2.microsoft.com/en-us/library/ms189887.aspx Sql:Variable() Function http://ms...

xml

0 1140 posted 16 years ago by rengber

SQL Simple Technique to Subtract Years from an Oracle Date

Oracle

0 1029 posted 16 years ago by rengber

SQL List all Stored Procedures in an Oracle Database

0 5821 posted 16 years ago by rengber

SQL Using a BitMask in a Where Clause

sql

0 561 posted 16 years ago by rengber

SQL Update Trigger to Increment a Version Number Column

database

0 710 posted 16 years ago by rengber

SQL Search Stored Procedure Code for a String

sql

0 675 posted 16 years ago by rengber

SQL Get the Code of a Stored Procedure as Text

sql

0 810 posted 16 years ago by rengber

SQL Script to Create a Script Granting EXECUTE to all Stored Procs in a DB

0 868 posted 16 years ago by rengber

SQL Oracle DateTime Interval

Oracle

0 540 posted 17 years ago by rengber

SQL Oracle Stored Proc to Return a Recordset (Oracle Side)

Oracle

0 672 posted 17 years ago by rengber

« Prev 1 Next »