存储过程 输出参数问题?
Create proc GetDvr
@xIP nVarchar(20),
@OutData nVarchar(1000) output
as
begin
select @OutData='IP:'+@xIP
print @outdata
print @xIP
end
declare @OutDatax nVarChar(1000)
begin
set @OutDatax = ''
exec GetDvr'192.168.0.64',@OutDatax
print @OutDatax
end
过程内部的打印的值是对的
IP:192.168.0.64
192.168.0.64
怎么 Print @OutDatax 的值为NULL 呢?