Answer Posted / balasubramaiam s( ramco system

Table variables are Transaction neutral. They are variables
and thus aren't bound to a transaction.

Temp tables behave same as normal tables and are bound by
transactions.

BEGIN TRAN
declare @var table (id int, data varchar(20) )
create table #temp (id int, data varchar(20) )

insert into @var
select 1, 'data 1' union all
select 2, 'data 2' union all
select 3, 'data 3'

insert into #temp
select 1, 'data 1' union all
select 2, 'data 2' union all
select 3, 'data 3'

select * from #temp
select * from @var

ROLLBACK

select * from @var
if object_id('tempdb..#temp') is null
select '#temp does not exist outside the transaction'


We see that the table variable still exists and has all
it's data unlike the temporary table that doesn't exists
when the transaction rollbacked.

Ways to improve the performance of a SQL Azure Database?

125

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

1083

---

What is an example of a primary key?

979

---

What is ssl in sql server?

1069

---

How to optimize stored procedure optimization?

890

---

What are the purposes and advantages stored procedure?

950

---

What is the difference between update lock and exclusive lock?

971

---

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

2579

---

write an SQL query to list the employees who joined in the month of January?

1674

---

what are database files and filegroups? : Sql server database administration

941

---

How can you tell if a database object is invalid?

1072

---

What is bcnf normalization form?

1105

---

What is set nocount on?

934

---

Do you know what are the ways available in sql server to execute sql statements?

1024

---

How to stop a loop early with break statements in ms sql server?

1013

---