新增文章

文章标题 分类 C# 云星空 K3 BOS K3 功能 用友 Oracle python SQL MySql PHP HTML script windows Access 影视后期 财务 服务 生活 内容 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ --【视图】 删除 if exists (select * from sys.views where object_id = OBJECT_ID(N'dbo.a_ICReportKeywords')) drop view dbo.a_ICReportKeywords go ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --【视图】 a_ICReportKeywords 直接SQL报表 关键字 create view dbo.a_ICReportKeywords as select * ,'insert into ICReportKeywords ( FInterID,FKeyword,FCaption,FCaption_CHT,FCaption_EN,FValueType,FDataSource,FBaseField,FSourceSql,FSourceField,FISAllowEnter,FISNeed,FLookUpType,FKeywordType ) ' +'select ' + convert(varchar(50),FInterID) +' ,'''+ FKeyword +'''' +' ,'''+ FCaption +'''' +' ,'''+ FCaption_CHT +'''' +' ,'''+ FCaption_EN +'''' +' ,'+ convert(varchar(50),FValueType ) +' ,'+ convert(varchar(50),FDataSource ) +' ,'+ convert(varchar(50),FBaseField ) +' ,'''+ FSourceSql +'''' +' ,'''+ FSourceField +'''' +' ,'+ convert(varchar(50),FISAllowEnter ) +' ,'+ convert(varchar(50),FISNeed ) +' ,'+ convert(varchar(50),FLookUpType ) +' ,'+ convert(varchar(50),FKeywordType ) FTxt from ICReportKeywords /* ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ select * from a_ICReportKeywords ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ select * from ICReportKeywords ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ */ go 返回 保存