[thelist] .NET: Can't get Stored Proc to Return a Value

Casey Crookston caseyb at thecrookstons.com
Tue Feb 12 22:10:36 CST 2008


Some how I removed a WHERE in my query for this short verison.   The actual 
stored proc reads:

DECLARE @NoCategory int
SELECT @NoCategory = COUNT(*) FROM table WHERE CategoryID IS NULL
/* print @NoCategory */

RETURN @NoCategory 




More information about the thelist mailing list