SQLTeam.com | Weblogs | Forums

Procedure get the in value to display in the out value

sql2014

#1

I would like to know how to get the "IN" VALUE of a procedure to be displayed in the "OUT" value.

IN citySearch1 varchar(30),
IN citySearch2 varchar(30),
IN citySearch3 varchar(30),
OUT City1 varchar(30),
OUT City2 varchar(30),
OUT City3 varchar(30)

When the procedure is executed the values that you enter in the "IN" how can I get those to be displayed in the "OUT" VALUE


#2

This does not seem like T-SQL syntax. What are CitySearch1, City1 etc? Are they columns in a table, or are they parameters of a stored proc, or something else?