what is the importence of the trigger in sqlserver2000?
Answer Posted / 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 View All Answers
What is the order in which the sql query is executed?
What are sp_configure commands and set commands?
what is the primary use of the model database? : Sql server administration
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
Can you type more than one query in the query editor screen at the same time?
How do I find the port number for sql server?
What is forward - only cursors / read only cursor?
How can we get count of the number of records in a table?
What is transact-sql ddl trigger?
Explain go command in sql server?
What happens if null values are involved in bitwise operations?
Explain different types of Normalization.
What are the components of dbms?
Explain trigger and trigger types?
Mention the different authentication modes in sql server.