rengber

Member since 07/25/2006

Location: New Zealand

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

13 snippets

4810 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 SnippetsTagged sql

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 788 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 730 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 716 posted 14 years ago by rengber

SQL TSQL for Recursive Select Using Common Table Expressions

0 731 posted 16 years ago by rengber

SQL SQL To Show WaitTime and other Process Stats

0 597 posted 16 years ago by rengber

SQL TSQL to Concatenate Subquery Row Values into a Column Value

0 804 posted 16 years ago by rengber

SQL TSQL to Reset a Tables Primary Key Autonumber

0 588 posted 16 years ago by rengber

SQL Add a Constant Value to a RecordSet

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

0 618 posted 16 years ago by rengber

SQL List all Stored Procedures in an Oracle Database

0 5830 posted 16 years ago by rengber

SQL Using a BitMask in a Where Clause

0 567 posted 16 years ago by rengber

SQL Search Stored Procedure Code for a String

0 678 posted 16 years ago by rengber

SQL Get the Code of a Stored Procedure as Text

0 814 posted 16 years ago by rengber

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

0 871 posted 16 years ago by rengber