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 types of storage modes? : sql server analysis services, ssas
Explain what are magic tables in sql server?
What do you mean by a dependent functionality in a build?
What are trace files?
How to download and install microsoft sql server management studio express?
What are the differences between triggers and stored procedures?
What is command parameter in ssrs?
What is the main purpose of having conversation group?
Delete duplicate rows without using rowid.
What is read committed?
How to select some specific rows from a table in ms sql server?
What are data files?
How to declare and use cursor variables?
what are isolation levels? : Sql server database administration
What is temporary table in sql server? Why we use temp table?