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.

What happens if you insert a duplicate key for the primary key column in ms sql server?

977

---

what is spatial nonclustered index

993

---

Do you know what is difference between stored procedure and user defined function?

1094

---

What is subreport?

142

---

How would you go about developing a ssrs report?

168

---

How can we rewrite sub-queries into simple select statements or with joins?

981

---

What is the use of group by clause?

943

---

What is the use of commit?

1001

---

What is the meaning of resultset type_scroll_insensitive?

956

---

Explain stored procedure?

1056

---

Explain about integration services of Microsoft SQL server?

1035

---

Explain the third normal form(3nf)?

946

---

Explain what are the authentication modes in sql server?

1019

---

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1198

---

Is natural join and equi join same?

974

---