sql stored procedure output parameters

Stored Procedure with output parameter

CREATE PROCEDURE [dbo].[usp_OutPara]

@x int output,

@s varchar(max)

AS

BEGIN

set @x=1

select @s

END

Execute the stored proc and read the output variable

DECLARE @x INT

DECLARE @x2 INT

DECLARE @s VARCHAR(MAX)

set @s='hello world'

EXEC Usp_outpara

  @x=@x2 OUTPUT,

  @s=@s

SELECT @x2 --Displays 1

To read the output variables in asp.net check out 

http://dotnetanalysis.blogspot.com/2011/09/adonet-with-examples.html