transation can be rollback in temptable but in tablevaribale we cannot do

What is the difference between Temporary table variable and
a Table variable?

Or

Which Table variable I should use inside Stored procedure?

Question Posted / jagadeesh

Answer Posted / jagadeesh

transation can be rollback in temptable
but in tablevaribale we cannot do this

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is it safe to delete log files?

899

What is a transact-sql statement batch in ms sql server?

995

What is dbcc updateusage?

1176

What are the requirements on sql server network connections?

948

What is checkpoint process in the sql server?

1006

how you can list all the tables in a database?

1013

When I run the sql server 2000 setup, it just hangs. What do I do?

1065

What is nonclustered index on computed columns?

938

Explain error handling in ssis?

1002

Explain differences between web edition and business edition?

119

How raid can influence database performance?

1011

Explain Geometry datatype in sql server 2008 with example

957

What is difference between sql and sql server?

974

What is bit data type? What's the information that can be stored inside a bit column?

905

What do you understand by physical_only option in dbcc checkdb?

966