In the last chapter we saw how we could use local variables and conditional processing to control the flow of logic in a stored procedure. We also saw how we could use error handling to check for errors and to raise our own errors. All of these features help to make our stored procedures more sophisticated and robust. This chapter expands on that knowledge and introduces new concepts, more T-SQL statements, and further functions that will aid you in writing more sophisticated stored procedures.
KeywordsSystem Assignment Update Statement Query Window Update Data Query Analyzer
Unable to display preview. Download preview PDF.