Snipplr - rengber http://snipplr.com/users/rengber/tags/sql Recent snippets posted on Snipplr.com en-us Fri, 29 Aug 2008 20:11:12 GMT (C#) ASP.Net Page to Return an Image from an SQL Blob Query http://snipplr.com/view/5549/aspnet-page-to-return-an-image-from-an-sql-blob-query/

]]> Mon, 24 Mar 2008 21:36:37 GMT http://snipplr.com/view/5549/aspnet-page-to-return-an-image-from-an-sql-blob-query/ (SQL) TSQL for Recursive Select Using Common Table Expressions http://snipplr.com/view/5547/tsql-for-recursive-select-using-common-table-expressions/

]]> Mon, 24 Mar 2008 18:00:18 GMT http://snipplr.com/view/5547/tsql-for-recursive-select-using-common-table-expressions/ (SQL) SQL To Show WaitTime and other Process Stats http://snipplr.com/view/5498/sql-to-show-waittime-and-other-process-stats/

]]> Wed, 19 Mar 2008 22:55:37 GMT http://snipplr.com/view/5498/sql-to-show-waittime-and-other-process-stats/ (SQL) TSQL to Concatenate Subquery Row Values into a Column Value http://snipplr.com/view/5497/tsql-to-concatenate-subquery-row-values-into-a-column-value/

]]> Wed, 19 Mar 2008 22:54:33 GMT http://snipplr.com/view/5497/tsql-to-concatenate-subquery-row-values-into-a-column-value/ (SQL) TSQL to Reset a Tables Primary Key Autonumber http://snipplr.com/view/5102/tsql-to-reset-a-tables-primary-key-autonumber/

]]> Sun, 17 Feb 2008 20:42:49 GMT http://snipplr.com/view/5102/tsql-to-reset-a-tables-primary-key-autonumber/ (SQL) Add a Constant Value to a RecordSet http://snipplr.com/view/4683/add-a-constant-value-to-a-recordset/ Noob stuff, but I always end up looking this up.

]]> Sun, 20 Jan 2008 19:46:57 GMT http://snipplr.com/view/4683/add-a-constant-value-to-a-recordset/ (SQL) List all Stored Procedures in an Oracle Database http://snipplr.com/view/3776/list-all-stored-procedures-in-an-oracle-database/

]]> Mon, 24 Sep 2007 15:31:54 GMT http://snipplr.com/view/3776/list-all-stored-procedures-in-an-oracle-database/ (SQL) Using a BitMask in a Where Clause http://snipplr.com/view/3660/using-a-bitmask-in-a-where-clause/

]]> Sun, 09 Sep 2007 19:17:07 GMT http://snipplr.com/view/3660/using-a-bitmask-in-a-where-clause/ (SQL) Search Stored Procedure Code for a String http://snipplr.com/view/2642/search-stored-procedure-code-for-a-string/

]]> Tue, 15 May 2007 21:40:35 GMT http://snipplr.com/view/2642/search-stored-procedure-code-for-a-string/ (SQL) Get the Code of a Stored Procedure as Text http://snipplr.com/view/2641/get-the-code-of-a-stored-procedure-as-text/

]]> Tue, 15 May 2007 21:39:15 GMT http://snipplr.com/view/2641/get-the-code-of-a-stored-procedure-as-text/ (SQL) Script to Create a Script Granting EXECUTE to all Stored Procs in a DB http://snipplr.com/view/2603/script-to-create-a-script-granting-execute-to-all-stored-procs-in-a-db/

]]> Sun, 06 May 2007 14:47:51 GMT http://snipplr.com/view/2603/script-to-create-a-script-granting-execute-to-all-stored-procs-in-a-db/ (C#) Get the Return Value from an SQL Stored Procedure http://snipplr.com/view/2373/get-the-return-value-from-an-sql-stored-procedure/

]]> Wed, 21 Mar 2007 20:32:32 GMT http://snipplr.com/view/2373/get-the-return-value-from-an-sql-stored-procedure/ (C#) SQL Stored Proc to Generate a list of C# constants representing data field names. http://snipplr.com/view/1767/sql-stored-proc-to-generate-a-list-of-c-constants-representing-data-field-names/

]]> Thu, 07 Dec 2006 14:58:14 GMT http://snipplr.com/view/1767/sql-stored-proc-to-generate-a-list-of-c-constants-representing-data-field-names/