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?
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
Which Model uses the SET concept
What are the events recorded in a transaction log?
How to view existing indexes on an given table using sp_help?
What is equi join with example?
What are different types of raid configurations? : SQL Server Architecture
How to generate create view script on an existing view?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
What are different types of collation sensitivity?
What is dbcc command in sql server?
Does group by sort data?
Is there any difference between the primary key and unique key?
Explain transaction server consistency?
Explain tables in SQL Azure?
What is difference between materialized view and view?
What Are the Main Features of SQL Azure?