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 are the different ways to return the rowcount of a table?
whats the maximum size of view state??
how to do partition in sqlserver
Explain concepts of analysis services?
What have included columns when we talk about sql server indexing?
Why do you need a sql server?
What is normalization and denormalization in sql server?
What do you know about normalization and de- normalization?
what are user defined datatypes? : Sql server database administration
What is the simplest way to create a new database in ms sql server?
Do you know what is replace and stuff function in sql server?
Explain about protocol layer present in SQL server?
How do I start sql server 2016?
How to sort the query output with order by clauses in ms sql server?
What will be the maximum number of index per table?