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.

How to Get the Output of a Stored Procedure into a Table

Putting the output of a stored procedure into a table provides you multiple options for parsing and using the output with other TSQL commands. Read on to learn more.