O'Reilly logo

Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required