Creating Your First Stored Procedure

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

Working with SQL Server Stored Procedures and .NET

Learn how to build a simple .NET application that uses SQL Server stored procedures to retrieve and update data from a database.

Temporary Tables and Stored Procedures

String Replace in Stored Procedures with Powershell

Find a string in a stored procedure and replace with powershell

Using Parameters for SQL Server Queries and Stored Procedures

One of the benefits of SQL is the ability to write a query and use parameters to dynamically act upon the resultset. Depending on the situation, there can be benefits to parameterizing queries, but it is not always clear when or how to do this. In this tip we look at different ways to pass in values as parameters to queries and the advantages and disadvantages.

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

Find UDF useage

Find all stored procedures that use UDFs

EXECUTE as SELF

Execute As Security