Displaying results of Output parameters in QA

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?
LVL 15
dbbishopAsked:
Who is Participating?
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
exec hr_lookup_zipcode '64063',@city output,@State output
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:

declare @city nvarchar(30)
declare @state nchar(2)

exec hr_lookup_zipcode '64063',@city OUTPUT,@State OUTPUT
select @city,  @state
0
 
Atlanta_MikeCommented:
exec hr_lookup_zipcode '64063',@city  OUTPUT,@State OUTPUT
0
 
dbbishopAuthor Commented:
You guys are on the ball!
0
 
Atlanta_MikeCommented:
Oh yeah... jilt me... :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.