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
- 9214 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 is an active database?
Can foreign key be duplicate?
Explain different types of collation sensitivity?
If a table does not have a unique index, can a cursor be opened on it?
What is difference between equi join and natural join?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Explain what are partitioned views and distributed partitioned views?
What is default constraint in ms sql server?
What is resource governor in sql server?
What are the main differences between #temp tables and @table variables and which one is preferred?
What are the characteristics of modern DBMS?
Why we use the openxml clause?
Which joins are sql server default?
What method is used by the Command classes to execute SQL statements that return single values?
Do you know sql server 2008 backup compression?
