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
- 5 Answers
- 24151 Views
- I also Faced
- E-Mail Answers
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
Can we shrink data file in sql server?
Can one drop a column from a table?
How to convert character strings into numeric values?
do you know how to configure db2 side of the application? : Sql server database administration
Explain system functions or built-in functions? What are different types of system functions?
How can I check that whether automatic statistic update is enabled or not?
What are the source of constraints?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What are the different subsets of sql?
What is acid mean in sql server?
Why should you use or avoid select * statements?
How do I find query history in sql server?
What is sql or structured query language?
What is self contained sub query?
