Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / subbarayudu
A Trigger is a block of code,fired whenever data in the underlying table is affected by any of the Data Manipulation Language (DML) statements -INSERT,UPDATE,OR DELETE.
whenever trigger fires,two special tables are created-
1.insert table 2.Delete table.
1.inserted table contains copy of all records that are insetred in the trigger table.
2.deleted table contains all records that have been deleted from trigger table.this table is used to refer old values.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is lookup override?
How except clause is differs from not in clause?
How to connect of datebase with sql express.?
How to connect to a sql server using odbc_connect()?
Why Master database is required?
What type of Index will get created after executing the above statement?
How do you check sql server is up and running?
What happens if an integer is too big for int date type?
How to locate and take substrings with charindex() and substring() functions?
Is it possible in sql table to have more than one foreign key?
What is the use of stored procedure?
How to make a remote connection in a database?
can you implement data mining in SSRS?
What is the Disadvantage of indexed sequential file.
What is the use of builtinadministrators group in sql server? : sql server security
