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
- 9073 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
How to get nth highest salary from employee table.
Do you know what is a trace frag? Where do we use it?
How to download and install the scaled-down database adventureworkslt?
Tell me what is de-normalization and what are some of the examples of it?
What are the new scripting capabilities of ssms? : sql server management studio
What is the new security features added in sql server 2016? : sql server security
Difference between drill down and drill through report.
which table keeps the locking information? : Sql server administration
How can you find out which stored procedures are recompiling?
What the difference between UNION and UNIONALL?
Explain tablesample?
What is CTE in SQL
What is an sql server agent?
How many types of cursor type are there?
What are the restrictions applicable while creating views? : SQL Server Architecture
