Interested to Buy Any Domain ? << Click Here >> for more details...
What is cursor ? And what is difference between Trigger ?
- 3 Answers
- 31832 Views
- HCL, Polaris, I also Faced
- E-Mail Answers
Answer Posted / bhaskar
Cursor is an Database object and retrive the rows from
database row by row ,
And it is maily use for ot reduce the network traffic
it contains 5 features
1.DECLARE the Cursor
2.OPEN the cusrsor
3.FETCH the cursor
4.CLOSE the cursor
5.DEALLOCATE the cursor
TRIGGER : IT is also an database object and You can
perform an anction Trigger will fire automatacallly.
like (DML,DDL)
They can cascade changes through related tables in the
database; however, these changes can be executed more
efficiently using cascading referential integrity
constraints.
They can guard against malicious or incorrect INSERT,
UPDATE, and DELETE operations and enforce other
restrictions that are more complex than those defined with
CHECK constraints.
Multiple DML triggers of the same type (INSERT, UPDATE, or
DELETE) on a table allow multiple, different actions to
take place in response to the same modification statement.
| Is This Answer Correct ? | 53 Yes | 10 No |
Post New Answer View All Answers
What is data compression?
What are the different types of Indexes available in SQL Server?
What is buffer cash and log cache in sql server?
What is triggers in ms sql server?
Does sql server 2000 full-text search support clustering?
What is scan table/view and seek table/view when its occurs? : sql server database administration
What is fill factor and pad index?
How to display a past time in days, hours and minutes?
What is sql server schema compare? How we can compare two database schemas?
What do we need queues in sql service broker?
What is nonclustered index on computed columns?
Where is localdb stored?
What is page in sql server?
1 01 101 01010
Why SQL Agent is used?
