return code of the previously called procedure

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.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

return code of the previously called procedure

Author

Topic

kam
Starting Member

17 Posts

Posted - 2006-03-15 : 15:59:30

Is there any way to access/use it.

I.e. My procedure returns a 1 if true and 0 if false.

I call the procedure as such:

EXEC pointInP @subID, @xPoint, @yPoint, 'true'

I would like to see what return value the procedure brought back.. can someone suggest how I can achieve that?

Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-03-15 : 16:00:25

DECLARE @rc int
EXEC @rc = pointInP @subID, @xPoint, @yPoint, 'true'

Tara Kizer
aka tduggan

kam
Starting Member

17 Posts

Posted - 2006-03-15 : 16:43:32

many many thanks that.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources