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
- 8248 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 is a DBMS, query, SQL?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
How connect excel to sql server?
How many columns can we include on clustered index ?
Define tool Manage Statistics in SQL Server 2000 query ?
How do I determine how many instances of sql server are installed on a computer?
What are the system database in sql server 2008?
Describe triggers features and limitations?
What is primary key and example?
How do I view a stored procedure in sql server?
What are different types of subquery?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
Define a cross join?
Explain different types of lock modes in sql server 2000?
What does truncate do?
