27,579
社区成员
发帖
与我相关
我的任务
分享
update A
set kkk00 ='2010'+substring(A.kkk01,1,8)+'01'
FROM KKK A,
server.master.dbo.qqq b
where a.kkk00=b.kkk00 COLLATE french_CI_AS
--这样?
select '2008',a.* from kkk a, server.master.dbo.qqq b
where a.kkk00=b.kkk00 COLLATE french_CI_AS) b
update kkk
set kkk00 ='2010'+substring(a.kkk01,1,8)+'01'
from kkk a , server.master.dbo.qqq b
where a.baza01 = b.baza01
update kkk
set kkk00 ='2010'+substring(b.kkk01,1,8)+'01'
from kkk a , server.master.dbo.qqq b
where a.baza01 = b.baza01
update A
set kkk00 ='2010'+substring(kkk01,1,8)+'01'
FROM KKK A,
server.master.dbo.qqq b
where a.kkk00=b.kkk00 COLLATE french_CI_AS