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
- 9337 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 is a full text index?
Mention the different authentication modes in sql server.
What are the extra roles available in msdb? : sql server security
Explain insert into select statement?
Explain alternate key, candidate key and composite key in sql server?
How to execute stored procedure and set temp table in sql server?
What do you mean by cardinality?
Explain time data type in sal server 2008?
What is history table in sql server?
How do you rebuild an identity column?
What are sub reports?
How many tables can be joined in SQL Server?
What is the fillfactor concept in indexes?
How do I install only the client tools of sql server 2000?
How to rebuild all indexes on a single table?
