What is the difference between Temporary table variable and
a Table variable?
Or
Which Table variable I should use inside Stored procedure?
- 3 Answers
- 8563 Views
- Microsoft, TCS, Techastrum, I also Faced
- E-Mail Answers
Answer Posted / kava
instance varialble
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is acid mean in sql server?
What is self contained sub query?
How to connect php with different port numbers?
Can you index views?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
How do I find the sql server version?
What are the properties of the transaction?
What is standby servers? Explain types of standby servers.
If any stored procedure is encrypted, then can we see its definition in activity monitor?
Does view occupy space?
Explain “row_number()” in sql server with an example?
How to convert character strings into numeric values?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Explain system functions or built-in functions? What are different types of system functions?
