SQLServerCentral / Discuss Content Posted by Robert Cary / Article Discussions / Article Discussions by Author

Serializing Procedure Calls Without Uneccesssary Blocking

Robert Michael Cary — Mon, 16 Oct 2006 09:38:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/rcary/2649.asp

SQL Server 2005 Paging – The Holy Grail

Robert Michael Cary — Tue, 10 Mar 2009 22:33:41 GMT

Comments posted to this topic are about the item [B]SQL Server 2005 Paging – The Holy Grail[/B]

URLEncode

Robert Michael Cary — Mon, 31 Mar 2008 16:19:26 GMT

Comments posted to this topic are about the item [B]URLEncode[/B]

Search All Columns in all tables

Robert Michael Cary — Sun, 23 Sep 2007 21:09:56 GMT

Comments posted to this topic are about the item [B]Search All Columns in all tables[/B]

Searching Syscomments Accurately

Robert Michael Cary — Tue, 02 Jan 2007 11:55:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/rcary/2792.asp

Find Nth Occurrence of Character Function (Set Based)

Robert Michael Cary — Mon, 08 Oct 2007 20:18:24 GMT

Comments posted to this topic are about the item [B]Find Nth Occurrence of Character Function (Set Based)[/B]

RE:

Bryan Aldrich — Thu, 08 Feb 2007 20:38:00 GMT

Um, but if you are running Sql Server 2005, can't you just query sys.sql_modules and return the entire definition as a NVARCHAR(MAX) field? no need to concat or anything.

Bryan

RE:

Martin Heys — Mon, 22 Jan 2007 03:00:00 GMT

I have a 1900 line stored proc in SQL2K which has 24 rows in syscomments.

Our solution was to use a VB string datatype and control the analysis in the app after the whole procedure had been read in.