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 / mari
declare cursor, open cursor and close cursor
| Is This Answer Correct ? | 4 Yes | 29 No |
Post New Answer View All Answers
Explain transaction server consistency?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
How to execute multiple stored procedures at one time in sql server?
How to connect Azure federated root database and apply federation in entity framework?
What command do we use to rename a database?
What is the cpu pressure?
How to create an identity column?
How to create hyperlink from returned sql query ?
Which is better statement or preparedstatement?
How to delete database objects with "drop" statements in ms sql server?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
How to select true false based on column value in sql server?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
How does a profiler work?
Can I use sql azure as a backup with log shipping or database mirroring?