T-SQL批量操作的实现,存储过程

ALTER PROCEDURE [dbo].[gqlm_UpdateAdminAuditeInfo]
 @strID Varchar(500)
AS
 EXEC(‘UPDATE [ad_info] SET [sf_auditing]=1 WHERE [id] IN (‘ + @strID + ‘)’)
GO
 

ALTER PROCEDURE [dbo].[gqlm_UpdateAdminAuditeInfo]
 @strID Varchar(500)
AS
 EXEC(‘UPDATE [ad_info] SET [sf_auditing]=1 WHERE [id] IN (‘ + @strID + ‘)’)
GO
 

发表评论