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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only