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
- 6194 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
How do you create type- insensitive operator?
Differentiate between a having clause and a where clause.
Where are sql server user names and passwords stored in sql server?
What is sqlservr.exe - process - sql server (sqlex?press)?
How to create an index on a view?
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.
How to delete a login name in ms sql server?
What is the difference between a local and a global temporary table?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Find nth lowest salary or get nth lowest salary?
How can you find out which stored procedures are recompiling?
Do you know what is lock escalation?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is temporary stored procedure?
Can you explain what are commit and rollback in sql?
