What is the difference between Temporary table variable and
a Table variable?
Or
Which Table variable I should use inside Stored procedure?
- 3 Answers
- 7149 Views
- Microsoft, TCS, Techastrum, I also Faced
- E-Mail Answers
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
Write a sql query to get zero records from a table having n number of records?
Can sql servers linked to other servers like oracle?
Call by value and call by reference in procedure and function, with NOCOPY.
What is unpivot?
How to enter date and time literals in ms sql server?
What is coalesce in sql server?
What happens on checkpoint?
What’s the distinction between dropping a info and taking a info offline?
Can you explain different types of locks in sql server?
What is difference between inner join and join?
What is a DBMS, query, SQL?
How do we synchronize On-Premise SQL server with SQL Azure?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
Explain what is the main purpose of having conversation group?
Why we use the openxml clause?
