asked
After inserted Trigger
Hi I have Created After inserted Trigger on [Item] Table.when I inserted record in Item Table trigger working fine but when I inserted 2nd time error generated Duplicat record .I want to know why .when I drop trigger then all working fine .Please give me solution . trigger is given below Create Trigger dbt_RND_NewItem ON [Item] After Insert AS update Item Set Item.[Item Reclass] = 1 from [Item] Item ,Inserted Ins where Item.No_ = Ins.No_ and (Item.No_ like '742%' or Item.No_ like '743%')
hi , I am using Set NOCount ON in my trigger then problem solved .
@Akhilesh When you set Set Item.[Item Reclass] = 1, you are getting something from a table other than the inserted table. There should be a JOIN to enable that table to be seen.
1 Person is following this question.
