Interested to Buy Any Domain ? << Click Here >> for more details...
wat is mean by trigger?.......normally wat use......when
trigger used in sql...........
plz cleary say with example.......
- 2 Answers
- 6326 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / radhakrishnan vaithilingam
Def Trigger : bascially trigger means "activate or generate
or fire".if we touch any column automaticcaly some event
accure in database.
use :
1) if update or insert or delete more than one table we can
use this concept.
2) trigger reduce coding error and reduce wrong action
3) we can trace the system login or logoff inforamtion.
this is system trigger.
example :
1) bank account
if we retrive the money from ATM. the money automatically
reduced from your account immediate.
2) fire alarm
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the recovery models in sql server 2000?
Does order by actually change the order of the data in the tables or does it just change the output?
What are types of storage modes? : sql server analysis services, ssas
What is the minimum recommended amount of ram for sql server 2012 enterprise?
What is the use of floor function in sql server?
What are the types of stored procedures in an sql server?
How to use linked server?
What is difference between joins and subqueries?
How to convert numeric values to integers in ms sql server?
How to create a view on an existing table in ms sql server?
How can you find out which stored procedures are recompiling?
What is BCNF? How is it better than 2NF & 3NF?
Does a sql server 2005 select statement require a from?
What is the difference between a clustered index and a non-clustered index?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
