when I write a stored procedure to pass in the input and get the output of phrase_content all I get is a null value. What am I doing wrong? Why can't I get the value of phrase_content when using a stored procedure?
ALTER PROCEDURE [dbo].[get_PhraseContent] -- Add the parameters for the stored procedure here@application char,@phrase_number char,@language char,@gender char,@phrase_content binary OUTPUTASBEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here SELECT @phrase_content = phrase_content from phrase_index where application = @application and phrase_number = @phrase_number and language = @language and gender = @genderEND