Answer Posted / vijay
The set of rows is returned by SELECT statementb by using
WHERE clause or not. In our application can not work
EFFICIENTLY to this result set. If we want to
access/process the entire block or row or fields or it
different kind of property, we need the mechanism. This
mechanism is called CURSOR.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How you can get the list of largest tables in a database?
What is the difference between function and stored procedure in sql server?
Difference between LEN() and DATALENGTH() in sql server ?
What is difference between Datepart() and Datename() in SqlServer?
What is encryption key?
Explain subquery and state its properties?
Explain what is the difference between a local and a global temporary table?
What is nolock?
What is difference between createstatement and preparedstatement?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What is the security principal at the database level that represents your session?
Can we return Data from 4(more than 1) tables in stored procedure?
If a stored procedure is taking a table data type, how it looks?
How to set the current database in ms sql server?
What are the three different part of rdl file explain them?
