⟩ Explain Forward – only cursors?
Forward – only cursors: This cursor supports updates but not scrolling. It supports only fetching serially. Rows are not retrieved from the database until they are fetched.
Forward – only cursors: This cursor supports updates but not scrolling. It supports only fetching serially. Rows are not retrieved from the database until they are fetched.
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
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?