Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-11 : 08:35:32
|
Robert writes "SQL 2000 BOL in the section 'Using @@error' gives a sample stored proc called SampleProcedure in Northwind (without using transactions) which demonstrates the use of @@error. Page 517 in S&D 'Inside SQL Server 7' demonstrates the same use of @@error.
But when I try and duplicate the behavior in Query Analyser 2000 using
declare @ret int,
exec @ret = storedproc
select @ret
by simulating a typical error eg an invalid table name, the behavior is exactly opposite to BOL and ISS.
What I get is the error text but obviously it has aborted before setting and displaying @@error.
Help much appreciated.
Regards
Robert
Australia
" |
|
|
|
|
|
@@error behavior