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 |
|
dhh166
Starting Member
2 Posts |
 Posted - 2012-06-23 : 03:55:30
|
| I wrote an UPDATE trigger AFTER INSERT, but it affects each row in each time ,I want to affect only last raw I inserted in each time , please help |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-06-23 : 04:46:13
|
why do you want to do that ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-23 : 13:36:24
|
| do you've an identity column or an audit column like datecreated?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2012-06-25 : 11:58:26
|
| http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxhttp://www.sqlservercentral.com/articles/Best+Practices/61537/ |
|
|
|
|
|
|
I want trigger to affect one raw at one time