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
How many types of schemas are there?
Explain primary key and foreign key constraints?
What is create command?
What is a benefit of using an after insert trigger over using a before insert trigger?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
What are translations and its use? : sql server analysis services, ssas
What are secondary xml indexes?
How to get the definition of a stored procedure back?
What are views used for?
What is the use of builtinadministrators group in sql server? : sql server security
What is log cache in sql server?
What are the differences between user defined functions and stored procedures?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
explain what is raid and what are different types of raid configurations? : Sql server database administration
How except clause is differs from not in clause?