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
- 6167 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 happens when converting big values to numeric data types?
What is the difference between functions and scalar functions?
What is b tree index?
what is a schema in sql server 2005? : Sql server database administration
What encryption security is available in sql azure?
How do users use Report Builder with SQL Server data sources?
What is the difference between sdf and mdf?
Explain timestamp datatype?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
Mention the differences between local and global temporary tables.
What is the purpose of data source?
Explain go command in sql server?
What is the difference between clustered index and primary key?
How to perform key word search in tables?
What is difference between clustered index and non clustered index?
