What is the difference between deallocate cursor and close cursor?


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

Post New Answer

More SQL Server Interview Questions

Explain the database you used in your final year project?

0 Answers   Wipro,


What is Extended user-defined?

0 Answers  


what's the difference between a primary key and a unique key? : Sql server database administration

0 Answers  


How many instances per computer are there in sql server 2000?

0 Answers  


How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 Answers  






What is thr feature of change data capture?

0 Answers  


How to list all columns in a table using odbc_columns()?

0 Answers  


what are acid properties? : Sql server database administration

0 Answers  


Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,


Define left outer join?

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   HCL,


What options are available to audit login activity? : sql server security

0 Answers  


Categories