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
- 9193 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
3) fetching the cursor
4)close the cursor.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
what are user defined datatypes and when you should go for them? : Sql server database administration
can any body tell me how to know the password of current user in sql server
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
How to override dml statements with triggers?
Explain the types of indexes.
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
What is the default server name for sql server?
How do you open a cluster administrator?
How to recreate an existing index in ms sql server?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
What is the syntax to execute the sys.dm_db_missing_index_details?
Explain can SSRS reports Cache results?
Which are the two editions in which SQL Azure database available?
How to declare a cursor with "declare ... Cursor" in ms sql server?
What are subquery and its properties?
