Interested to Buy Any Domain ? << Click Here >> for more details...
1.what is the purpose of using alias name in sql server?
with certain example?
2.what is cursor?will u plz explain me in detail with
certain example?
- 3 Answers
- 9191 Views
- I also Faced
- E-Mail Answers
Answer Posted / lekhrajdeshmukh
Cursor:- Cursor is special data type of mssql server.
Cursor is mainly used for extracting the row by row data
from tables.
cursor is the only data type that can not be used in table.
Cursor is mainly used in stored procedure and when we have
to use cursor in SP need to perform the following steps:-
1)declaring a cursor.
2)Open a Cursor
4)close the cursor.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Is foreign key unique?
Explain the difference between primary keys and foreign keys?
Distinguish between commit and rollback?
Delete duplicate rows without using rowid.
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
Ways to improve the performance of a SQL Azure Database?
Explain sql server service broker?
how would you store your query in an SSRS report or a Database server?
How to create percentile function?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
How the authentication mode can be changed?
What happens if null values are involved in datetime operations?
How do I connect to sql server database?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
How can you list all the columns in a database?
