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

What do you know about normalization and de- normalization?

543

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

671

explain different types of constraints? : Sql server database administration

605

What is difference between getdate and sysdatetime in sql server 2008?

686

Define left outer join?

682

Can we call stored procedure in trigger?

639

What new changes are being made in SQL Server?

674

Which is the latest version of sql server and when it is released?

644

Can we call future method from queueable?

673

How would you add a section to a table?

669

List some major differences between triggers and stored procedures?

595

What is an expression in ms sql server?

635

What is sql server profiler?

662

Can truncate be rolled back?

617

Describe and explain about SQL native client?

691