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 16. Using VB to Design SQL Server Stored Procedures

Just as you can execute a stored procedure written in T-SQL, you can also execute a stored procedure written in Visual Basic .NET. You’ll probably agree that writing business logic in Visual Basic .NET is easier than writing it in T-SQL. As you’ll see, the process of setting up a stored procedure written in Visual Basic .NET is somewhat more complicated than that of T-SQL. Fortunately, after you get the hang of it, it’s not bad at all. In this hour you’ll learn

How to execute a simple Visual Basic .NET 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 ...

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