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
Get Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
