Which stored procedure runs most often? My small SQL Server 2005 script finds the most used stored procedure, with execution count, worker time and calls per second.
Porting Stored Procedures Between Platforms
Porting stored procedures means preserving error, transaction, temporary-table, sequence, and date behavior instead of translating tokens.
SSIS or T-SQL for a Simple Load
SSIS or T-SQL for a simple load depends on sources, transformations, logging, and operations; learn when a stored procedure is enough.
Writing Tests for Stored Procedures
Write tests for stored procedures with arrange, act, and assert steps in T-SQL, isolated data, and a repeatable check before every change.
SQL SERVER – Correct Syntax for Stored Procedure SP
What is the correct syntax for stored procedure code? Anything between BEGIN and END is part of the procedure, and anything after GO is not, as my examples show.
SQL SERVER – 2005 – List All Stored Procedure in Database
Want to see all stored procedure in database at once? Run SELECT * FROM sys.procedures. This simple query works only with SQL Server 2005.
SQL SERVER – 2005 2000 – Search String in Stored Procedure
Two scripts to search a string in stored procedure code, one for SQL Server 2000 using syscomments and one for SQL Server 2005, clearly labeled by version.