摘要:
1.select stuff((select ','+a.exttextfield1 from project a where ','+ b.field027 +',' like '%,'+cast(a.id as varchar(32))+',%' for xml path('') ),1,1,' 阅读全文
摘要:
select * from docbase where isdelete=0update docbase set subject=STUFF(subject,23,4,'****') where isdelete=0 update docbase set subject=STUFF(subject, 阅读全文
摘要:
update formlayoutfield set formula='''$currentuser$''=field001 or ((select orgid from humres where id=''$currentuser$'')=''402880ec5c99d3bd015c9a17bba 阅读全文