Interested to Buy Any Domain ? << Click Here >> for more details...
what is the importence of the trigger in sqlserver2000?
- 1 Answers
- 4444 Views
- ATI, I also Faced
- E-Mail Answers
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
How to list all triggers in the database with sys.triggers in ms sql server?
What is dknf in normalization form?
What are the different authentication modes in sql server?
What is blocking and how would you troubleshoot it? : sql server database administration
what do you understand by change data capture?
How to get a list of columns in a view using the "sp_columns" stored procedure?
What are the different normalization forms?
How to use user defined functions in expressions?
How do you rename a table in sql server?
What are the advantages of log shipping?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
Does index speed up select statements?
Does the unique constraint create an index?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
Explain about Views?
