what is the importence of the trigger in sqlserver2000?

Question Posted / sharifuddin

1 Answers
4378 Views
ATI, I also Faced
E-Mail Answers

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 use column default values in insert statements in ms sql server?

0 Answers

what is a deadlock? : Sql server database administration

0 Answers

Find nth lowest salary or get nth lowest salary?

0 Answers

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

0 Answers

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

0 Answers

What is awe?

0 Answers

How do I delete a sql server database?

0 Answers

How do you rebuild an identity column?

0 Answers

What are cursors?

8 Answers

wat wil hapn if we give the both read and deny read permission to user?