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
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
Which autogrowth database setting is good?
What does it mean to normalize data?
What are distributed partitioned views?
Do you know what is a with(nolock)?
Can group functions be mixed with non-group selection fields in ms sql server?
What is the difference between having clause and where clause in sql server?
What are the different types of triggers in SQL SERVER?
How does clustered and non clustered index work?
List out the difference between union and union all in sql server?
Write an sql query to find first weekday of the month?
How will you decide the active and passive nodes?
What is dbcc updateusage?
Explain the disadvantages of cursors?
What is the language structure to add a record to a table?