What is cursor ? And what is difference between Trigger ?
Answers were Sorted based on User's Feedback
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 |
Answer / sanjay kumar dinda
Cursor is a database object used by applications to
manipulate data in a set on a row-by-row basis, instead of
the typical SQL commands that operate on all the rows in
the set at one time.
Trigger is a database object invoked automatically when any
event occured.
These aevents are
Delete, Insert, Update etc....
SQL server store the intermediate data into to dummy table
INSERTED and DELETED...
At the time of insert operation SQL Server STores inserted
rows into the INSERTED table and at the time of delete or
update SQL Server stores the information into DELETED dummy
table
Is This Answer Correct ? | 19 Yes | 7 No |
Answer / adisha
CURSOR:
1.They are temporary work areas.
2.They are not stored independently in the database.
3.We can create cursor both implicitly and explicitly.
4.Cursors can take parameters.
5.They are used to process the result of query.
TRIGGER:
1.They are named PL SQL blocks.
2. They are stored in database.
3. They can be invoked automatically.
4. They cannot take parameters.
5. They are used to enforce data in dignity rules.
Is This Answer Correct ? | 5 Yes | 1 No |
Why are you getting errors when creating a new odbc dsn?
How to start and end transact-sql statements?
Please illustrate physical database architecture? : SQL Server Architecture
How do SQL server 2000 and XML linked?
How to check table values in sql server?
Explain about analysis services?
Why foreign key column allowing null values even a parent tables reference key column not having null value..
Explain isolation levels that sql server supports?
What is the difference between delete and truncate statements?
What is create statement?
How to delete existing triggers using "drop trigger"?
What is unpivot?