09 2023 档案

摘要:select exttextfield6 from assets where charindex(id,'8a070cd88ab2a995018ad0c69def060a,8a070cd88ab2a995018ad0c69ffb0625') > 0 实例:select stuff((select ' 阅读全文
posted @ 2023-09-28 17:28 java璀璨小菜鸟 阅读(66) 评论(0) 推荐(0) 编辑
摘要:1.select stuff((select ','+a.exttextfield1 from project a where ','+ b.field027 +',' like '%,'+cast(a.id as varchar(32))+',%' for xml path('') ),1,1,' 阅读全文
posted @ 2023-09-25 16:35 java璀璨小菜鸟 阅读(94) 评论(0) 推荐(0) 编辑
摘要:select * from docbase where isdelete=0update docbase set subject=STUFF(subject,23,4,'****') where isdelete=0 update docbase set subject=STUFF(subject, 阅读全文
posted @ 2023-09-08 13:50 java璀璨小菜鸟 阅读(42) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示