⟩ What is Static Cursor?
Static Cursor: Stores a complete copy of the result set. Used mostly where scrolling is required. Static cursors don’t support updates.
Question and Answer:
Home MS SQL Server Cursors
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What are defaults? Is there a column to which a default can't be bound?
How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is database replication? What are the different types of replication you can set up in SQL Server?
What are different types of BACKUPs available in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What is the difference between DELETE TABLE and TRUNCATE TABLE commands?
What is a major difference between SQL Server 6.5 and 7.0 platform wise?
What is new philosophy for database devises for SQL Server 7.0?
What is a traditional Network Library for SQL Servers?
If you encounter this kind of an error message, what you need to look into to solve this problem?
