create table #t(A varchar(10),b numeric(28,2))
insert into #t select '1*2*3',null
insert into #t select '2*3*4',NULL
declare @sql nvarchar(4000)
select @sql = isnull(@sql+' ','')+'Update #t set B = ' + A + ' where A=''' + A+ ''''
from #t
exec( @sql)
select * from #t
drop table #t
sql计算表达式
最新推荐文章于 2024-06-26 19:26:03 发布