Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours

HOUR 18. Using C# to Design SQL Server Stored Procedures

Just as you can execute a stored procedure written in VB, you can also execute a stored procedure written in C#. As you’ll see, the process is identical. It’s only the language that’s different. In this hour you’ll learn

• How to execute a simple stored procedure

• How to declare and work with variables

• How to control the flow of the stored procedures that you create

• How to work with input and output parameters

• How to use stored procedures to modify data

By the Way

The examples in this hour can be run with the Express edition of C#.

Executing a Simple Stored Procedure

By the Way

You will notice that this hour is almost identical to Hour 16. The intention is to show you how ...