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
Define self join in sql server joins?
Define full outer join?
How to create a dml trigger using create trigger statements?
What is the difference between DataRow.Delete() and DataRow.Remove()?
Explain nested trigger in sql?
Can we use custom code in ssrs?
Can I run multiple instances of sql server 2000 at the same time on one computer?
How to see the event list of an existing trigger using sys.trigger_events?
What type of Index will get created after executing the above statement?
What is the command to change the recovery model?
Why normalization is used?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
Explain difference between cross join and full outer join?
Mention the 3 ways to get a count of the number of records in a table.
What is read uncmmited?