Interested to Buy Any Domain ? << Click Here >> for more details...
What is cursor ? And what is difference between Trigger ?
- 3 Answers
- 31681 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 are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
What are the system database in sql server 2005?
Do you know how to implement service broker?
Define compound operators?
Explain collation?
explain different types of joins? : Sql server database administration
What are the indexes in sql server?
Can sub report data source be different from that of the parent report?
What is rtm version in sql server?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
What are the tools available in market as an alternative to sql server reporting services?
What is single-user mode?
How to declare a cursor with "declare ... Cursor" in ms sql server?
What is key attribute?
What is merge join?
