what is the importence of the trigger in sqlserver2000?



what is the importence of the trigger in sqlserver2000?..

Answer / kinthada cnu

hi all

Trigger nothing but special kind of stored procedure
it's providing security to table data.And it is automatically
fire when the queary excuted.

ex:
create trigger <trigger name>
on <table name>
for <insert/update/delete>
as
begin
<statments>
end

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More SQL Server Interview Questions

How to list all user names in a database?

0 Answers  


What are the five major components of a dbms?

0 Answers  


Do you know what is a with(nolock)?

0 Answers  


what changed between the previous version of sql server and the current version? : Sql server database administration

0 Answers  


Explain the new features of SQL server 2000?

1 Answers  






After removing a table from database, what other related objects have to be dropped explicitly?

0 Answers  


do you know how to configure db2 side of the application? : Sql server database administration

0 Answers  


Differentiate between ms sql server reporting services vs crystal reports?

0 Answers  


How to populate a table in sql server?

0 Answers  


Differences between logshipping and mirroring

1 Answers   Microsoft, Syntel,


What is service broker?

0 Answers  


Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

0 Answers  


Categories