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

How to find the login name linked to a given user name?

1002

What is page-level compression?

950

what purpose does the model database serve? : Sql server database administration

963

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

906

Can binary strings be converted into numeric or float data types?

1021

What are the advantages to use stored procedures?

1098

What is the difference between a check constraint and a rule?

1230

Explain the types of indexes.

1198

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1131

How can I create a new template for import ? : sql server management studio

1063

How to reaname table name without using sp_Rename in sql server..?

979

What is exporting and importing utility?

1071

Explain what are the events recorded in a transaction log?

997

What is sql server profiler trace data file?

1100

What is cursor in ms sql server?

1136