Community

Making Stored Procedures Readable

(Andrew Novick) Stored procedures can grow to be quite lengthy. I’ve created procedures that are 500 to 1000 lines or more. There are a couple of reasons for this, including the limited coding structure provided by T-SQL. In particular, the limited error handling in SQL Server 2000 forces constan

Read More - Register for Free Membership