新增文章

文章标题分类内容

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【视图】 删除

if exists ( select * from sys.views where object_id = OBJECT_ID(N'dbo.a_ICField') )
               drop     view                                         dbo.a_ICField
   go
   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【视图】 a_ICField  金蝶老单 所有字段

create view dbo.a_ICField
   as 
      select FID,FBillName,FPage,FSort,FCtlIndex,FTabIndex,FTableName,FTableAlias,FFieldName,FCaption,FCaption2,FFullName
      from aICTemplateAll
      
      union all
      select FID,FBillName,FPage,3 FSort,FInterID,FSort,FTableName,FTableAlias,FColName,FColCaption,FCaption2,FFullName
      from aICChatBillTitle

/*
------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select * from a_ICField  where FID = 'S01' and FFieldName like '%%' order by FFieldName,FSort,FTabIndex   -- 金蝶老单 所有字段
   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
*/
go