What is the difference between temp table and table variable?
Answer Posted / nalla
Temporary variables logs very less into transaction log, so
compare to Temp tables, temp varaibles are good in
performance wise.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What is filter index?
How to write a query with an inner join in ms sql server?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What do you understand by hotfixes and patches in sql server?
Which rendering formats are affected by the pagesize properties?
How can change procedure in sql server?
What are the built in functions in sql server?
Explain different types of self contained sub query?
How to create a new table in a given schema?
What is a subquery in a select query statement in ms sql server?
What the different components of Replication and what is their use?
What are distinctive joins find as a part of sql?
How to turn on the mssql api module in php?
What is table value parameters (tvp)?