Call by value and call by reference in procedure and function, with NOCOPY.


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

Post New Answer

More SQL Server Interview Questions

What are a database and a data warehouse?

0 Answers  


Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  


Explain transaction isolation levels in sql server?

0 Answers  


Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,


Explain few examples of stored procedure over triggers?

0 Answers   ADITI,






Explain why variables called the most powerful component of ssis?

0 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  


what is joins please explain breffly ??

1 Answers   Adaequare, TCS,


What happens if null values are involved in boolean operations?

0 Answers  


What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

0 Answers  


what is web server?

3 Answers   Satyam,


can you any body tell me which service pack is installed in the sql server?

3 Answers  


Categories