sql - Handle stored procedure output -

i have procedure:

alter procedure [xyz].[stored_proc]     @input1 int,      @input2 nvarchar(255) begin     set nocount on;      update ...     set input1=@input1     input2=@input2 ,     input3 not in (123) end 

i want catch update clause output , return procedure output parameter, can handle in .net code. how can achieve this?

i don't see output clause yet - if did have it, need run stored procedure if returned result set (from select statement):

using (sqlconnection conn = new sqlconnection(-your-connection-string-here-)) using (sqlcommand cmd = new sqlcommand("[xyz].[stored_proc]", conn)) {     cmd.commandtype = commandtype.storedprocedure;      conn.open();      // execute update statement output clause sqldatareader     using(sqldatareader reader = cmd.executereader())     {         // read values returned output clause         while(reader.read())         {             int insertedid = reader.getint32(0);             // values....                         }     }      conn.close(); } 

this assuming update statement inside stored procedure this:

update ... output inserted.id    -- or else.... set input1 = @input1 input2 = @input2    , input3 not in (123)