Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Nature of sprocs

Author  Topic  Carlos Starting Member 6 Posts Posted - 2001-02-02 : 07:18:37 Hi Community I've started writing my first stored procedures, and writing complex SELECT's is not a problem. The problem comes when I must perform several operations, for example, updating a table and then returning the ID of the row just updated, and so on... Is there any special order or commands I've to use to achieve this? BEGIN TRAN and COMMIT TRAN are required? Thanks, Carlos