Hi guys,



When you want to run a particular section of the query, you normally
select that portion and press F5 to run it.



1. Now what will happen if I press cancel button (red square) when the
query is running



2. If it is an update query, will the data written to the table be
rolled back.



3. Also if in case of a stored procedure which updates the table.



Currently I have two recursive procedures under the selection and I am
canceling in between, will the updation

Done in these procedure be rolled back.



4. What if one procedure has finished its execution





I am quite new to sql server hence a detail description would be helpful



Thanx in advance

bye


MS Sql Server LazyDBA home page