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 / shaik
There is no affect in DB while changing in both casess.
Is This Answer Correct ? | 21 Yes | 5 No |
Post New Answer View All Answers
What is autocommit mode in sql server?
Write the SQL query to drop, truncate and delete table.
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is filtered index?
How can I tell if sql server is 32 or 64 bit?
Do you know the policy based administration feature of sql server 2008?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
How to define the name and server for a new dsn?
How to delete an existing row with delete statements in ms sql server?
How to optimize stored procedures in sql server?
What is measure group, measure? : sql server analysis services, ssas
Explain why variables called the most powerful component of ssis?
Give an example of why you would want to denormalize a database
Explain what are various ways to enhance the ssrs report?
How sql server executes a statement with nested subqueries?