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 / avinash
Change in view would not reflect chg in db but in cursor it
would.
Is This Answer Correct ? | 5 Yes | 32 No |
Post New Answer View All Answers
How many clustered indexes there can be on table ?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is the most common trace flags used with sql server?
what is denormalization? : Sql server database administration
How to display a past time in days, hours and minutes?
Explain aggregate functions?
What is usually the first word in a sql query?
What is the difference between join and inner join?
What is normalization? Describe its different types.
What is reportserver and reportservertempdb ?
What is the sql case statement used for? Explain with an example?
What command is used to create a database in the sql server and how?
How to use subqueries in the from clause in ms sql server?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What are the two authentication modes in sql server?