Interested to Buy Any Domain ? << Click Here >> for more details...
What is cursor ? And what is difference between Trigger ?
- 3 Answers
- 31487 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 save transaction and save point?
How to transfer an existing table from one schema to another schema in ms sql server?
What language is sql server written in?
What are different types of roles provided by ssrs?
What is sqlservr.exe - process - sql server (sqlex?press)?
How do I view a stored procedure in sql server?
What is open database communication (odbc)?
What is the openxml statement in sql server?
What are diverse clauses that form a part of sql?
What are alternate keys?
What is schemabinding a view?
What is the largest component inside a field?
What is normalization and its types?
what's the information that can be stored inside a bit column? : Sql server database administration
When we should use and scope of @@identity?
