What is the difference between Temporary table variable and
a Table variable?
Or
Which Table variable I should use inside Stored procedure?
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
Why is the need for data conversion transformations?
Why we need sql server?
What are the different types of replication you can set up in sql server?
what is blocking? : Sql server database administration
How to delete database objects with "drop" statements in ms sql server?
How to execute stored procedure in select statement sql server?
What is the difference between function and stored procedure in sql server?
How to include date and time values in sql statements?
how would you improve etl (extract, transform, load) throughput?
Distinguish between commit and rollback?
What are the extra roles available in msdb? : sql server security
How many ways to create table-valued functions?
How many triggers you can have on a table?
What is scrollable cursor?
How to delete existing triggers using "drop trigger"?