samantha72
Programmer
Hi I am trying to send the stored procedure 2 parameters as inputs. one is language and the second is the country id and i would like to get the description back as an output but this is not working. Please help
CREATE PROCEDURE dbo.DisplayCountry_pr
@language int, @countryid int,
@countrydesc varchar(35) out
AS
BEGIN
if @language = 1
Select @countrydesc = english_desc from country
where @countryid = country_id
else
Select @countrydesc = french_desc from country
where @countryid = country_id
END
CREATE PROCEDURE dbo.DisplayCountry_pr
@language int, @countryid int,
@countrydesc varchar(35) out
AS
BEGIN
if @language = 1
Select @countrydesc = english_desc from country
where @countryid = country_id
else
Select @countrydesc = french_desc from country
where @countryid = country_id
END