Senator Guerra Souty original series calendar,replica hublot blue steel peach pointer collocation of rolex replica Rome digital scale, track type minute replica watches scale shows that the classical model is swiss replica watches incomparable, wearing elegant dress highlights.
mr-ponna.com

 

YOU ARE HERE: HOME Questions Can i rollback table data types when we are using in transactions

Effect of rollback on "table data types" in SQL Server

 View(s): 48192

Can i rollback "table data types" when we are using in transactions?

Answer 1)

Table data types are un affected by the rollback. This is one of the reasons why table variables are sometimes preferred over #temp tables (reduced logging overhead).

This behaviour can also be quite useful for persisting some information that you want to process after arollback.

It is easy to test.

begin tran
declare @t table (c int)
insert into @t values(1)
rollback

select * from @t

Returns

c
-----------
1

  Asked in:  Accenture   Expertise Level:  Experienced
  Last updated on Friday, 06 June 2014
3/5 stars (31 vote(s))

Register Login Ask Us Write to Us Help