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
- 9091 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
Do you know the cursor types?
What is database isolation in sql server? : sql server database administration
Can we join two tables without primary key?
What are the fixed server level roles? : sql server security
‘Order by’ is not allowed in a view how can you sort information from a view?
How to change the data type of an existing column with "alter table" statements in ms sql server?
Can sql servers linked to other servers?
How to install sql server 2005 express edition?
How can I change procedure name in sql server?
What is the difference between TRUNCATE and DROP?
Why would you use sql agent?
What are the different type of replication in sql server?
What is partition in sql server?
Explain syntax for viewing, dropping and disabling triggers?
What type of Index will get created after executing the above statement?
