(This is part of the Study Guide series, 70-457)
Microsoft’s Measured Skill description: This objective may include but is not limited to: write a stored procedure to meet a given set of requirements; branching logic; create stored procedures and other programmatic objects; techniques for developing stored procedures; different types of stored procedure results; create a stored procedure for data access layer; program stored procedures, triggers, and functions with T-SQL
What I see:
· stored procedure results
· create stored procedures
Stored Procedure Results
I go into quite a bit detail about the difference types of stored procedure results, and returning data to the calling code in this SQL Salt blog post. In summary, stored procedures have a few ways of returning data, but often times there are different requirements to use each method, such as returning a result set, or returning execution status (success or failure). To see examples and a fuller explanation, read the linked blog post.
Create Stored Procedures
Again, this was covered in the same SQL Salt blog post as above. Not much to it, but there are a lot of “gotchas” that could arise. Read the blog post, but also see BOL for corner-cases that aren’t always widely known.
If there are any comments, questions, issues, or suggestions please feel free to leave a comment below or email me at firstname.lastname@example.org.