In this article I am going to explain how to get stored procedure schema. Basically we are not interested in the result set, just the schema of the result returned. What you do with the schema is, I leave it to your imagination. I am going to use AdventureWorks for my example. So add the […]
Transactions are often used within stored procedures to guarantee that all steps succeed or all steps fail. For Example, if you want to insert data into header table and line tables, ideally you would want the data to be inserted into both header and line tables or you do not want both of the inserts to fail.