Very Computer

>Hello,

>    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
values
>and put them in a command line )

>    Thanks for your response !

>    Jack

>The table inserted includes ALL rows inserted in the command wich caused
the
>trigger to fire. You'll have to create some code to deal with this. A
cursor
>would do the job of looping through each row, however I think it's better
to
>do it with a subquery instead. It depends on what you want to do with the
>rows.

>/micke

>>Hello,

>>    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
>values
>>and put them in a command line )

>>    Thanks for your response !

>>    Jack