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 / bindu
Both Cursors and Views doesn't store data , so their is no chance to affect the DB.
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
How do you run a trace?
What are the advantages of sql stored procedure?
When I run the sql server 2000 setup, it just hangs. What do I do?
How to maintain a fill factor in existing indexes?
What is a document index?
What are different types of constraints?
What is role playing dimension with two examples? : sql server analysis services, ssas
How to use union to merge outputs from two queries together in ms sql server?
Why do we need different type of parameter?
How to concatenate two binary strings together?
How to view the error log for any specific instance? : sql server database administration
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
Explain cdc and sql injection?
Explain error and transaction handling in sql server?