declare @doc int
set @doc=1
use workflow_dist_hebeiupdate instancelist
set nodeid=10112,instancename='借方审核' where instanceinfo like '%<docid>&@doc</docid>%'这条语句执行怎么没有反映,所影响行数为0
set @doc=1
use workflow_dist_hebeiupdate instancelist
set nodeid=10112,instancename='借方审核' where instanceinfo like '%<docid>&@doc</docid>%'这条语句执行怎么没有反映,所影响行数为0
declare @doc int
set @doc=1
use workflow_dist_hebei
update instancelist
set nodeid=10112,instancename='借方审核' where instanceinfo like '%<docid>@doc</docid>%'
set @doc=1set @exec='update instancelist
set nodeid=10112,instancename=''借方审核'' where instanceinfo like ''%<docid>@doc</docid>%'''
exec @exec
set nodeid=10112,instancename='借方审核'
where instanceinfo like '%<docid>' + rtrim(@doc) + '</docid>%'
set @doc=1
use workflow_dist_hebeiupdate instancelist
set nodeid=10112,instancename='借方审核'
where charindex('<docid>'+convert(varchar(10,@doc))+'</docid>',instanceinfo)>0
set @doc=1set @exec='update instancelist set nodeid=10112,instancename=''借方审核'' where instanceinfo like ''%<docid>'+@doc+'</docid>%'''
print @exec
先执行一下print 显示的语句有什么问题没有!---exec @exec