Baku Local Free Classifieds

SQL Server 2008 Interview Questions and Answers Q.What Is Cursor? Ans: Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the rows in the set at one time. In order to work with a cursor we need to perform some steps in the following order: • Declare cursor • Open cursor • Fetch row from the cursor • Process fetched row • Close cursor • Deallocate cursor Q.What Is Collation? Ans: Collation refers to a set of rules that determine how data is s...