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

3 Answers
8369 Views
Microsoft, TCS, Techastrum, I also Faced
E-Mail Answers

Answer Posted / jagadeesh

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

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to how to convert numeric expression data types using the convert() function??

1051

What is the federation in sql azure?

What do you understand by the denormalisation?

957

What is a bit datatype?

987

How many levels of sp nesting is possible?

1056

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

923

How is SQL Azure different than SQL server?

225

What do you understand by a view?

997

how to avoid cursors? : Sql server database administration

969

Relational calculus is what type of language?

1036

what is a self join? Explain it with an example? : Sql server database administration

948

How are the exceptions handled in sql server programming?

1062

Why should one not prefix user stored procedures with ‘sp_’?

1046

how can a database be repaired? : Sql server administration

971

What does it mean to manipulate data?

992