What is the difference between Temporary table variable and
a Table variable?
Or
Which Table variable I should use inside Stored procedure?
Answers were Sorted based on User's Feedback
Answer / oliva
There are major theoretical differences between temporary tables:
Temp table will show below
create table #T (…)
Table var will show below
And table variables:
declare @T table (…)
scope of table var is only inside the Store Procedure.
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / jagadeesh
transation can be rollback in temptable
but in tablevaribale we cannot do this
| Is This Answer Correct ? | 1 Yes | 0 No |
What is sql server 2000 work load governor?
Can a function call a stored procedure in sql server?
What is store procedure? How do they work? When do you use?
What is bit datatype and what's the information that can be stored inside a bit column?
Difeerence between ssis 2005 and ssis2008?
What is buffer cash and log cache in sql server?
How to create a ddl trigger using "create trigger" statements?
What is cdc in sql server?
Write a sql query to delete duplicate records from a table called table1
What is single-user mode?
What are the different types of replication you can set up in sql server?
What is difference between rownum and row_number?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)