I recently put together a lesson on how to create stored procedures. It is part of my Stored Procedures Unpacked course. When you create stored procedures, you can encapsulate logic securely, while allowing client program an easy way to execute it. I put this walk through together so that you’ll see how the whole process […]
Continue readingAfter reading this article you will understand the basics of programming a stored procedure using IF…ELSE statements; most importantly how keywords, such as BEGIN, END, IF and ELSE affect the order of execution within your stored procedures. All the examples for this lesson are based on Microsoft SQL Server Management Studio and the sample databases […]
Continue reading