Thanks..
Hey, I have to graduate quickly and pass the bar so I can defend Alex Lifeson!!
>Hey John,
>
>>The only way to trap @@error is to encapsulate the call into a stored procedure. Rendering a sql insert and/or delete from the client will not provide an opportunity to trap and deal with the error.
>>
>>Also, subsequent calls to get @@rowcount are not reliable and ineffecient since you are 1 - not in the original tx and 2 - you have to make another trip to the server when 1 should suffice.
>
>And what do you think you're doing offering actual (and useful!) help to people? < vbg > I thought the only thing you did on the UT was tick people off. < s >
>
>Just thought I'd drop this in here to remind people of the quality and usefulness of the technical content you post on the UT.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement