Call by value and call by reference in procedure and function, with NOCOPY.
What are a database and a data warehouse?
Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?
Explain transaction isolation levels in sql server?
Find top Nth employee from each department in terms of salary?
Explain few examples of stored procedure over triggers?
Explain why variables called the most powerful component of ssis?
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 joins please explain breffly ??
What happens if null values are involved in boolean operations?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
what is web server?
can you any body tell me which service pack is installed in the sql server?