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
How to create a login account in ms sql server to access the database engine using "create login" statements?
What is difference between index seek vs. Index scan?
What is the default Port No on which SQL Server listens?
Explain Geometry datatype in sql server 2008 with example
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What Is Rdbms?
What is a derived table?
What is the stuff and how does it differ from the replace function?
What are subquery and its properties?
How you can add messages to the nt event log from within a stored procedure?
What are exact numeric data types in ms sql server?
What is dbcc updateusage?
How would you use user_constraints table in DB?
Do you know the capabilities of cursors?
How to get a list of all tables with "sys.tables" view in ms sql server?