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
- 5 Answers
- 22285 Views
- I also Faced
- E-Mail Answers
Answer Posted / mari
declare cursor, open cursor and close cursor
| Is This Answer Correct ? | 4 Yes | 29 No |
Post New Answer View All Answers
How to select all columns of all rows from a table with a select statement in ms sql server?
How to drop existing indexes in ms sql server?
What is similarity and difference between truncate and delete in sql?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
Explain what are the restrictions while creating batches in sql server?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
Explain the steps to create and execute a user-defined function in the sql server?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
How to write a query with a right outer join in ms sql server?
Define Business Edition in SQL Azure?
What is a rollup clause?
What are a database and a data warehouse?
What are the fixed server level roles? : sql server security
What is the architecture of ms sql reporting service?
What authentication modes does sql server support?
