Differentiate between sql temp table vs table variable?
No Answer is Posted For this Question
Be the First to Post Answer
What is rank function?
What is the tcp/ip port on which sql server runs?
What is bit data type?
plss anybody specify tha constrian management system in dbms
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?
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?
what is mean by crystal repoart? ahere we will mainly use that?
Explain the ways to controlling cursor behavior?
What happens if null values are involved in boolean operations?
A left outer join B B right outer join A gives the same result then what is the use of two?
Indexes are updated automatically is the full-text index also updated automatically?
How to replace given values with null using nullif()?