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
3) fetching the cursor
4)close the cursor.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is indexing explain it with an example?
Explain primary key and foreign key constraints?
How to delete database objects with "drop" statements in ms sql server?
What is indexed view? How to create it?
What is candidate key with example?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
How many types of functions are there in sql server?
How can we use ConnectorJ JDBC Driver with MS SQL?
What is conditional split?
Can you explain what is indexed view? How to create it?
What are the differences between decimal and float in ms sql server?
When would you use the stored procedures or functions?
What happens if ntwdblib.dll is missing on your machine?
What is standby servers? Explain types of standby servers.
What is partition, how will you implement it? : sql server analysis services, ssas