This is prbably too simple and I am just having a brain-freeze day (it was a rough nioght!).
I've got a procedure I want to execute in QA. It has 3 parameters, one input, two output (it actually looks up city and state based on zip code. I've done the following:
declare @city nvarchar(30)
declare @state nchar(2)
exec hr_lookup_zipcode '64063',@city ,@State
select @city, @state
I get null values for @city and @state. I've tried print @city also but get no output. How do i check the values returned by the procedure?