1.存储过程编写
create proc [dbo].[shuchu]
@id int ,--输入
@xxz varchar(500) output --输出
as
select @xxz=fieldstr8 from workflow_file where id=@id
2.调用存储过程
declare @xxz nvarchar(500)
exec shuchu '17',@xxz output
print @xxz
1.存储过程编写
create proc [dbo].[shuchu]
@id int ,--输入
@xxz varchar(500) output --输出
as
select @xxz=fieldstr8 from workflow_file where id=@id
2.调用存储过程
declare @xxz nvarchar(500)
exec shuchu '17',@xxz output
print @xxz