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 / avinash
Change in view would not reflect chg in db but in cursor it
would.
| Is This Answer Correct ? | 5 Yes | 32 No |
Post New Answer View All Answers
What is difference between temp table and cte?
How to make conditional sum in ssrs?
what is the difference between delete table and truncate table commands? : Sql server database administration
What is system stored procedures?
Explain primary key, foreign key and unique key?
What is stretch database in sql server?
How to use values from other tables in update statements in ms sql server?
Write a SQL query to delete a table?
What is sql azure database?
Can a table be moved to different filegroup?
What are the differences between ms sql server & oracle?
Who developed sql server?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What is the use of floor function in sql server?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?