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
- 6213 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 server-level principal?
Explain what are the authentication modes in sql server?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What do you understand by hotfixes and patches in sql server?
What is BCNF? How is it better than 2NF & 3NF?
What is raid? : SQL Server Architecture
What is the difference between for xml raw and for xml auto?
Is sql server implemented as a service or an application? : Sql server database administration
Explain the different index configurations a table can have?
What samples and sample databases are provided by microsoft?
How to create an identity column?
How to connect Azure federated root database and apply federation in entity framework?
What are sql server procedures?
What are trace flags and mention a few common trace flags used with sql server?
