Create and Alter Stored Procedures

(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

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s