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
- 7987 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 the advantages of using third-party tools?
What is the purpose of data source?
What are key constraints?
What does normalization do to data?
How to create an multi-statement table-valued function?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
When to use Inner join & when to use subquery?
Does full backup break log chain?
Explain primary key?
Explain nested join?
How to return the date part only from a sql server datetime datatype?
Write a sql query to display the current date?
What are system databases in ms sql server?
Can sql servers linked to other servers like oracle?
what is the difference between a primary key and a unique key? : Sql server database administration
