create proc sp_update asset xact_abort onbegin tranupdate 表名 set 类别 = 1 where 文章内容字段 like '%苹果%'update 表名 set 类别 = 2 where 文章内容字段 like '%镜子%' commit tranreturn 0
create proc p_TEST as UPDATE yTABLE SET TYPE = 1 WHERE CHARINDEX('苹果',yCOL) > 0 UPDATE yTABLE SET TYPE = 2 WHERE CHARINDEX('镜子',yCOL) > 0 GO
create procedure P as update table set type = 1 where *** like '$苹果$' update table set type = 2 where *** like '$镜子$' go
asset xact_abort onbegin tranupdate 表名 set 类别 = 1 where 文章内容字段 like '%苹果%'update 表名 set 类别 = 2 where 文章内容字段 like '%镜子%'
commit tranreturn 0
as
UPDATE yTABLE SET TYPE = 1 WHERE CHARINDEX('苹果',yCOL) > 0
UPDATE yTABLE SET TYPE = 2 WHERE CHARINDEX('镜子',yCOL) > 0 GO
as
update table set type = 1 where *** like '$苹果$'
update table set type = 2 where *** like '$镜子$'
go