>The table inserted includes ALL rows inserted in the command wich caused
>trigger to fire. You'll have to create some code to deal with this. A
>would do the job of looping through each row, however I think it's better
>do it with a subquery instead. It depends on what you want to do with the
I just want to take some informations like a loginName and a message that
are contain in a table that I use for history !
These informations are used in a command line to send a message to the
people name "loginName" !
>> I've a problem with an insert trigger on a table :
>> I must execute a command each time a row is inserted in my table ! To
>>perform that, i've make a trigger Insert !
>> But I failed to take all the new entries inserted ! I use the inserted
>>table but I can just take the last insert !
>> Is there an while instruction in SQL taht give me all line inserted or
>>what can I do to perform this action ! (For all entry I must take the
>>and put them in a command line )
>> Thanks for your response !