Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NewToSSIS
Starting Member
6 Posts |
 Posted - 2009-04-15 : 19:29:48
|
| Could someone please explain to me as to what is the use of Connotation, Inserted or Deleted while writing a trigger. I read about it but really couldnt wrap my head around it.So, can someone please explain to me as to what this is ... maybe an example would be fine too.thanks.,Robert. |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2009-04-15 : 20:44:27
|
| DML trigger statements use two special tables: the deleted table and the inserted tables. SQL Server automatically creates and manages these tables. They are memomy residents and can not be accessed outside execution contextBOL explains them in detailhttp://msdn.microsoft.com/en-us/library/ms191300.aspx |
 |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2009-04-15 : 20:50:03
|
| also, in SQL 2005 or later these tables are available when you use OUTPUT Clausehttp://msdn.microsoft.com/en-us/library/ms177564.aspx |
|
|
|
|
|
|
Writing a Trigger -- Inserted & Deleted