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 codes in SQL

Author  Topic 

Skydolphin
Starting Member

43 Posts

Posted - 2005-01-17 : 12:16:37
I am trying to read some stored procedures to backwards engineer some processes but since I'm not a SQL guru there are some things I am having trouble with. What does it mean when you have an if statement like this

IF @a = @b
RETURN 16

or here's another return code I don't know.

RETURN 4335


I'm running into many of these. Is there a list someplace of all the return codes and what they mean?

Thanks,

Rhonda

Rhonda

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-01-17 : 12:27:19
No, they don't mean anything, it's up to the application to interpret what they mean.
quote:
I am trying to read some stored procedures to backwards engineer some processes
Actually, you mean "reverse engineer". And besides, from what it looks like these processes are already engineered backwards.
Go to Top of Page

Skydolphin
Starting Member

43 Posts

Posted - 2005-01-17 : 18:13:32
If you're in reverse aren't you going backwards? What can I say it's Monday?

Rhonda

Rhonda
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2005-01-18 : 17:09:19
The only one that seems pretty consistent is that a zero means "no problem" or "successfully completed".

---------------------------------------------------------------------------------
Infoneering: Information Technology solutions engineered to professional standards.
Go to Top of Page
   

- Advertisement -