SqlServer获得存储过程的返回值
--创建存储过程
CREATE PROCEDURE procedure_test
@ID VARCHAR(100)
AS
DECLARE @ReturnValue varchar(100)
BEGIN
SET NOCOUNT ON;
set @ReturnValue = @ID
return @ReturnValue
END
GO
----
----执行下面sql语句,获得上面存储过程的返回值
declare @value varchar(100);exec @value = procedure_test '1111111';select @value