Creating a Stored Procedure

Defining Stored Procedures

Removing a version

Executing a stored procedure version

Stored Procedure Parameters

The Funny Stored Procedure Name

Creating Your First Stored Procedure

Learn how to get started writing code modules inside of your SQL Server database,

How to find a specific text string in a SQL Server Stored Procedure, Function, View or Trigger

How can I accurately find which SQL Server Stored Procedures, Views or Functions are using a specific text string, which can be a table name or anything like a string starting with 'XYZ'?

Stored procedure parameters

Can comments hamper stored procedure performance?

After a recent conversation on Twitter, Aaron Bertrand shows where excessive comments in your stored procedures might have an impact on performance.