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
- 7986 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
What do you mean by tablesample?
Do you know what is fill factor and pad index?
Explain the difference between control flow and data flow?
What command must you use to include the not null constraint after a table has already been created?
What are two difference between sql azure and azure tables?
How to make a column nullable?
Explain about unique identifier data type in sql server?
Do you know exporting and importing utility?
Explain how many types of relationship?
Explain what are page splits? : SQL Server Architecture
How to retrieve error messages using mssql_get_last_message()?
What is trace flag in sql server?
what is memory-optimized nonclustered indexes
What is key set driven?
How does a profiler work?
