只有注册用户登录后才能阅读该文。 阅读全文
摘要:
通过sql的stuff 把一列几行的记录拼接在一行一个字段 select FID,a.FCustomerID as 工地ID , 应验收节点 = (stuff((select ',' + isnull(t2.FName,'') from MD_ProjectPlanEntry t1 inner jo 阅读全文
摘要:
select * from T_META_FORMENUM_L where FNAME like '%进度状态%' select * from T_META_FORMENUMITEM a --(a.fvalue=) inner join T_META_FORMENUMITEM_L b on a.FE 阅读全文
摘要:
--辅助资料表 select * from T_BAS_ASSISTANTDATA_L where fname='主题' select * from T_BAS_ASSISTANTDATAENTRY where FID='57e3e16ee0ae9f' select * from T_BAS_ASS 阅读全文
摘要:
1 判断数据库是否存在 if exists (select * from sys.databases where name = '数据库名') drop database [数据库名] if exists (select * from sys.databases where name = '数据库名 阅读全文
摘要:
1 update T_META_OBJECTTYPE set FSUPPLIERNAME ='PAEZ',FPACKAGEID =null 阅读全文