ALTER proc [dbo].[test_exec] as begin declare @sql nvarchar(1000) declARE @Guid VARCHAR(100) SET @Guid='27f105da-647b-4954-a717-75c68e040f6a' set @sql='exec sp_Set_SysDetail @Guid' execute sp_executesql @sql,N'@Guid varchar(100) OUTPUT',@Guid OUTPUT end
as
begin
declare @sql nvarchar(1000)
declARE @Guid VARCHAR(100)
SET @Guid='27f105da-647b-4954-a717-75c68e040f6a'
set @sql='exec sp_Set_SysDetail @Guid'
execute sp_executesql @sql,N'@Guid varchar(100) OUTPUT',@Guid OUTPUT
end
,'@Guid varchar(100) OUTPUT'--有Output时 赋值时也需要,@Guid OUTPUT 这样才能获取返回值
execute sp_executesql @sql,N'@Guid varchar(100) ',@Guid