wat is mean by trigger?.......normally wat use......when
trigger used in sql...........
plz cleary say with example.......
- 2 Answers
- 5649 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
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What happens when the SQL Azure database reaches Max Size?
Can we write ddl in trigger?
When does a workload on SQL Azure get throttled?
What is the purpose of indexing?
What is transaction server distributed transaction?
What is PROJECTION Operation?
what is an extended stored procedure? : Sql server database administration
How will you decide the active and passive nodes?
How do you drop an index?
What is sub query and its properties?
What are the new data types are introduced in sql 2000?
What is the data tier application?
What is precedence constraint?
How to recreate an existing index in ms sql server?
