USE Northwind GO CREATE PROC spCheckContact @cst nchar(5), @TitleName varchar(10) OUTPUT AS {remainder of my sproc; deleted to prevent plagiarism}
When I attempted to run it like this:
EXEC spCheckContact 'ALFKI'
I get this error:
Msg 201, Level 16, State 4, Procedure spCheckContact, Line 0 Procedure or function 'spCheckContact' expects parameter '@TitleName', which was not supplied.
But @TitleName is specified as an OUTPUT parameter! How can I fix this?