Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Temporary table variable and
a Table variable?
Or
Which Table variable I should use inside Stored procedure?
- 3 Answers
- 8223 Views
- Microsoft, TCS, Techastrum, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How do you handle datasets larger than 50 gb?
Differentiate between mongodb vs. Sql server?
What are the differences between char and nchar in ms sql server?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
How to read data in a table with "select" statements?
How to execute a stored procedure in ms sql server?
How to link tables in sql server?
What are the purposes and advantages stored procedure?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
How do you make a trace?
what method you can use to reduce the overhead of Reporting Services data sources?
What are pages and extents? : SQL Server Architecture
How would you go about developing a ssrs report?
Describe triggers features and limitations?
What is difference between equi join and natural join?
