The Developer Arguments for Stored Procedures

Today Steve asks what reasons a developer has for using stored procedures.

Returning Info from Stored Procedures

Find SQL Server Stored Procedure Create, Modified, Last Execution Date and Code

In this tip we look at different scripts you can use to find when a SQL Server stored procedure was created, modified, last executed and to also return the code for the stored procedure.

Create, Alter, Drop and Execute SQL Server Stored Procedures

In this tip we look at some examples of how to get started with creating, modifying and deleting SQL Server stored procedures.

Exporting Stored Procedure Results to a Table

A quick trick from Pamela Mooney for getting results from a proc into a table.

Call SQL Server Stored Procedures with PowerShell using Parameter Objects

In this tip we look at how we can use PowerShell to validate input values into SQL Server stored procedures prior to execution of the stored procedure

Creating CRUD Stored Procedures in SQL

Back to the basics: learn how to Create, Read, Update and Delete operations are pivotal for any database application. Plus, you’ll see how to use Stored Procedures to manipulate data on the database side instead of on the application side.

Building Better Stored Procedures

In a followup, this article includes discussion of more advanced features of using stored procedures.

Scripting procedure versions

Creating a Stored Procedure