problems with return parameter of store procedure

Question

problems with return parameter of store procedure

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

K. Brian Kelley SSC Guru Points: 114704 More actions · Answer 1

Can you give snippets of your C# and T-SQL stored procedure? Make sure that you clean up any code to hide anything that might be sensitive your organization. That would help us figure out what's going on.

K. Brian Kelley
@kbriankelley

Frances L SSCarpal Tunnel Points: 4727 More actions · Answer 2

You need to look at your C# parameter set up. It was confused while I used that.

Dylan Peters SSC Eights! Points: 916 More actions · Answer 3

The return value of a stored proc is always an int. If you use a smaller type, like tinyint or smallint, it will be converted. If you try to return something like a varchar, it will return an error.

You can use an OUTPUT parameter to return a different type.

Dylan Peters
SQL Server DBA

cjensen SSC Veteran Points: 222 More actions · Answer 4

You might consider using a user defined function rather than a stored procedure.