What is cursor ? And what is difference between Trigger ?
- 3 Answers
- 30757 Views
- HCL, Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Are connections to sql server encrypted?
How to remove duplicate rows from table except one?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
Write an sql query for deleting duplicate rows?
How does stuff differ from the replace function?
What are a scheduled jobs?
How to include date and time values in sql statements?
What are the database objects? : SQL Server Architecture
How to delete exactly duplicate records from a table?
can an order by clause be used in a creation of a view?
What is the contrast between sql and mysql?
How to maintain a fill factor in existing indexes?
What are the main differences between #temp tables and @table variables and which one is preferred?
Name some of the open source software that you can use in alternative to SSR?
Explain Geography datatype in SQL Server
