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 |
How to list all user names in a database?
What are the five major components of a dbms?
Do you know what is a with(nolock)?
what changed between the previous version of sql server and the current version? : Sql server database administration
Explain the new features of SQL server 2000?
After removing a table from database, what other related objects have to be dropped explicitly?
do you know how to configure db2 side of the application? : Sql server database administration
Differentiate between ms sql server reporting services vs crystal reports?
How to populate a table in sql server?
Differences between logshipping and mirroring
What is service broker?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication