Viewing 2 posts - 1 through 2 (of 2 total)
Or, if you are not confident with directly modifying the system tables, you could do the following
alter table mytable add col3 char(1) NULL, col4_copy char(1) NULL
Update mytable set col4_copy =...
December 27, 2006 at 8:15 am
#680090
When you look at the @@Error variable, it it is reset to 0 afterwards.
So, to return it as a return from the stored procedure you would need to extract...
June 22, 2004 at 1:53 am
#511351