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 |
|
fredong
Yak Posting Veteran
80 Posts |
 Posted - 2007-03-21 : 09:51:04
|
| Hi,I have a table below Table AID ModDate InputDate Type1 12/1/05 12/3/05 22 1/13/06 1/30/06 53 2/14/06 2/23/06 4and I need to create a trigger to capture only if there is an Update on 'ModDate' with the 'Type' = 5 or an Insert row with the Type ='5'. The trigger will trigger to B table. Please advise. Thanksk |
|
|
|
|
|
Trigger for update and insert with select conditio