Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 23851 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
What is the difference between a check constraint and a rule?
Explain how to maintain a fill factor in existing indexes?
What is the new security features added in sql server 2016? : sql server security
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
what is the system function to get the current user's user id? : Sql server database administration
What is sql server profiler?
What are the tables in sql?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is the use of keyword with encryption.
Write down the syntax and an example for create, rename and delete index?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
Explain tablesample?
What is the purpose of update statistics and scope_identity() function?
What is table value parameters (tvp)?
What are the disadvantages of indexes?
