|
Can i Rollback the Table DataTypes while using Transactions in sql server?
Table data types are unaffected by rollback statements when using transactions.
Example:
begin transaction declare @emp table (empid int) insert into @emp values(10); insert into @emp values(20); rollback
select * from @emp -------------------------------- 10 20
even though you rollback the data table variables will persist the data.
http://
http://
Contributed by:
rajeev chandra
hi this is rajeev
Resourse address on xpode.com
http://www.xpode.com/Print.aspx?Articleid=614
Click here to go on website
|