rengber

Member since 07/25/2006

Location: New Zealand

17 snippets

2478 profile views

2 Comment(s) Posted

their Tags

Oracle Net url event sql forms windows script security command xml database aspnet simple data filter web excel image c php html style design math extension query array c#

Profile

Achievement

rengber's Recent 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 489 posted 12 years ago by rengber

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

Dead simple, but often forgotten.

1 477 posted 12 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 489 posted 13 years ago by rengber

SQL TSQL Function and Check Constraint to Ensure that a Parent Value is Present in the Table

If a "InReplyToID" is provided, it must be a valid MessageId

1 805 posted 13 years ago by rengber

C# ASP.Net Page to Return an Image from an SQL Blob Query

0 528 posted 14 years ago by rengber

SQL TSQL for Recursive Select Using Common Table Expressions

0 499 posted 14 years ago by rengber

SQL SQL To Show WaitTime and other Process Stats

0 398 posted 14 years ago by rengber

SQL TSQL to Concatenate Subquery Row Values into a Column Value

0 546 posted 14 years ago by rengber

SQL TSQL to Reset a Tables Primary Key Autonumber

0 381 posted 14 years ago by rengber

SQL Add a Constant Value to a RecordSet

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

0 399 posted 14 years ago by rengber

SQL List all Stored Procedures in an Oracle Database

0 4280 posted 14 years ago by rengber

SQL Using a BitMask in a Where Clause

0 354 posted 14 years ago by rengber

SQL Search Stored Procedure Code for a String

0 450 posted 15 years ago by rengber

SQL Get the Code of a Stored Procedure as Text

0 512 posted 15 years ago by rengber

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

0 525 posted 15 years ago by rengber

C# Get the Return Value from an SQL Stored Procedure

0 753 posted 15 years ago by rengber

C# SQL Stored Proc to Generate a list of C# constants representing data field names.

0 547 posted 15 years ago by rengber