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

between cast and convert which function would you prefer and why?

0 Answers  


Does index speed up select statements?

0 Answers  


what are three different authentications to connect linked servers?

1 Answers   CitiGroup,


What is difference beteen Migration and Upgrdation?

7 Answers   Satyam,


there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

9 Answers   tdfc, vsworx,






How to enable tcp/ip protocol on a sql server?

0 Answers  


how to delete duplicate rows from table

9 Answers   CSC,


Can an entity have two primary keys?

0 Answers  


explain different levels of normalization? : Sql server database administration

0 Answers  


What is difference between Datepart() and Datename() in SqlServer?

0 Answers   Infosys,


What is 2nf in normalization?

0 Answers  


What is a data collection table?

0 Answers  


Categories