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
How will you find out if there are expensive SQL statements running or not?
What is the advantage of sql server?
What is normalization? Describe its different types.
Can you explain what is the use of custom fields in report?
What is function of CUBE ?
What is the purpose of the tempdb database?
What is an indexing strategy?
What is transact-sql ddl trigger?
What is a primary index?
What is normalization? Explain its different types?
What are sql server functions?
How to optimize stored procedure optimization?
What is subreport?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security