CREATE Procedure IMS_Submit
(
@Qiyemingcheng nvarchar(50)
)
AS
INSERT INTO 基本信息(是否提交进入审批) VALUES(是)
WHERE
企业名称 = @Qiyemingcheng
GO
try:
CREATE Procedure IMS_Submit
@Qiyemingcheng nvarchar(50)
AS
declare @sql as nvarchar(200)
set @sql=INSERT INTO 基本信息(是否提交进入审批) VALUES(是)
WHERE
企业名称 = +@Qiyemingcheng
exec @sql
GO