What is cursor ? And what is difference between Trigger ?
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 a sub-report?
What stored by the model?
How can you start sql server in different modes?
Explain indexed views and partitioned view with their syntax.
How to create a dynamic cursor with the dynamic option?
How do I view a stored procedure in sql server?
What is resultset concur_updatable?
What is join and name different type of joins?
Can a trigger be created on a view?
What is etl - extraction, transformation, and loading?
What is the datatype of rowid?
What number aggregate functions are accessible there in sql?
What is a covering index?
How to convert numeric expression data types by assignment operations?
What is resource db in sql server?