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
- 6067 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 is the difference between substr and charindex in the sql server?
Can we insert data if clustered index is disabled?
What is difference between after and before?
How to create sub reports?
What do you understand by a stored procedure?
What stored procedure can you use to display the current processes?
Can sql server be linked with other servers like oracle?
what purpose does the model database serve? : Sql server database administration
How to test values returned by a subquery with the in operator?
How to change the system date and time from SQL Plus Terminal ?
What are distributed partitioned views?
How to list all user defined functions in the current database?
How to locate and take substrings with charindex() and substring() functions?
What is system stored procedures?
What is sql server used for?
