Differentiate between sql temp table vs table variable?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is rank function?

0 Answers  


What is the tcp/ip port on which sql server runs?

0 Answers  


What is bit data type?

0 Answers  


plss anybody specify tha constrian management system in dbms

0 Answers   Police Constable,


select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 Answers  






There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,


what is mean by crystal repoart? ahere we will mainly use that?

1 Answers  


Explain the ways to controlling cursor behavior?

0 Answers  


What happens if null values are involved in boolean operations?

0 Answers  


A left outer join B B right outer join A gives the same result then what is the use of two?

1 Answers  


Indexes are updated automatically is the full-text index also updated automatically?

0 Answers  


How to replace given values with null using nullif()?

0 Answers  


Categories