1.what is the difference between view and cursor?
2.If we do any change in view will it affect the
database,similarly when we do changes in cursor will it
affect the databse?with certain example?Thanks
Answer Posted / mari
declare cursor, open cursor and close cursor
Is This Answer Correct ? | 4 Yes | 29 No |
Post New Answer View All Answers
What do you understand by user-defined function in the sql server?
Explain system rowset functions?
What are the lambda triggers?
Difference between DELETE and TRUNCATE?
What is the purpose of grouping data in a report?
What is the difference between an index and a unique index?
Define candidate key, alternate key, and composite key.
What is Transparent Data Encryption?
How do indexes help, types?
How the authentication mode can be changed?
Can we return Data from 4(more than 1) tables in stored procedure?
What is scrollable cursor?
What is scheduled job and how to create it?
State the difference between union and union all?
Can a table be moved to different filegroup?