wat is mean by trigger?.......normally wat use......when
trigger used in sql...........
plz cleary say with example.......
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 to automatically create a log when an exception is being received into SQL Server?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
How to find tables without indexes?
What is efficiency data?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
what is database replication? : Sql server database administration
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is data source object?
What is data mart? : sql server analysis services, ssas
How to concatenate two strings in SQL Server.
Describe how to use the linked server?
How to test a dml trigger in ms sql server?
What is difference between table aliases and column aliases? Do they affect performance?
Explain filtered indexes?