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
- 9060 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
Why do we use sql limitations? Which constraints can we use while making a database in sql?
on line cluster can we make if yes tell me the procedure
What samples and sample databases are provided by microsoft?
How can you append an identity column to a temporary table?
Can you move the resources after pausing the node? : sql server database administration
Can a synonym name of a table be used instead of a table name in a select statement?
Where can you add custom error messages to sql server?
Does the order of columns in update statements matter?
How dts is used to extract, transform and consolidate data?
Find first and last day of current month in sql server
How to get the definition of a view out of the sql server?
What is right outer join in sql server joins?
Explain what is log shipping?
What is command parameter in ssrs?
What is difference between stored procedure and user defined function?
