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 are views in ms sql server?
Explain a join?
What is linked report?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
What is autocommit mode in sql server?
What is an sql server agent?
write an SQL query to list the employees who joined in the month of January?
What is difference between join and natural join?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
if no size is defined while creating the database, what size will the database have? : Sql server administration
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
How do I install only the client tools of sql server 2000?
What is the server name for sql management studio?
Can we deploy SSRS reports on our personal website?
Explain index in sql server?