Return output parameter

• adonweb

  SSC Journeyman

  Points: 82

  More actions

  June 11, 2008 at 5:28 am

  #125813

  How can i display the value of stored procedure output parameter using sql query analyser. I want to check the value of output parameter before sending to my web page .

• snk1983

  SSChasing Mays

  Points: 611

  More actions

  June 11, 2008 at 5:52 am

  #827172

  try this method

  Declare @OutputParameter Datatype

  EXEC StoredProcedurename

  ParameterValue1,

  ParameterValue2,..ParameterValue3,

  @OutputParameter OUTPUT

  Select @OutputParameter