CODE EXAMPLE FOR SQL

set a value by excuting stored procedure

// Call to the stored procedure, with an OUTPUT parameter
DECLARE @OutputParameter  datetime
       ,@ReturnValue      int

EXEC @ReturnValue= [YourStoredProcedure] [comma separated parameters if any] @OutputParameter OUTPUT
PRINT(@ReturnValue)