--创建存储过程test create procedure [dbo].[test] ( @I_MTR NVARCHAR (MAX), @I_TYPE NVARCHAR (MAX), @I_FAC NVARCHAR (MAX)) as BEGIN select * from [dbo].[BAS_DOC] END
生成的结果:
执行存储过程:
exec test @I_MTR='1501102006972',@I_TYPE='PDF',@I_FAC='10018'
结果:
shiruina 2018-07-25 17:06 原文
--创建存储过程test create procedure [dbo].[test] ( @I_MTR NVARCHAR (MAX), @I_TYPE NVARCHAR (MAX), @I_FAC NVARCHAR (MAX)) as BEGIN select * from [dbo].[BAS_DOC] END
生成的结果:
执行存储过程:
exec test @I_MTR='1501102006972',@I_TYPE='PDF',@I_FAC='10018'
结果: