【正文】 李曉哲，張曉輝，李祥勝. SQL Server 2022 ：人民郵電出版社,2022.[5] Inmon W the Date Wileyamp。.[6] Haarjinder S Gill，——客戶(hù)/京：清華大學(xué)出版,1997.[7] Kimball Ralph，Reeves Laura，Ross Margy，Thornthwaite Warren. The Data Warehouse Lifecycle Wileyamp。.[8] 林萍，2022， （1）.[9] 喻剛，(OLAP)，2022，21（11）.[10] CHINA，1996.[11]飛思科技產(chǎn)品研發(fā)中心，SQL Server 2022 ：電子工業(yè)出版社，2022.[12]飛思科技產(chǎn)品研發(fā)中心，SQL Server 2022 ：電子工業(yè)出版社，2022.[13] ：科學(xué)出版社,1998.[14] 王惠剛，：.[15] （第二版）.北京：清華大學(xué)出版社，2022.33附錄 數(shù)據(jù)表格建立的源程序1．折舊年限表(pany_zjnx)建表源程序： CREATE TABLE [dbo].[pany_zjnx] ([ame] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,[obj_name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,[zj_years] [int] NULL ,[zj_idea] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,[canzhi] [float] NULL ) 2．企業(yè)基本情況表（pany_total）建表源程序：CREATE TABLE [dbo].[pany_total] ([_id] [int] NOT NULL ,[ame] [char] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,[ccode] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,[rmoney] [float] NULL ,[faren] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,[cadd] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,[kinds] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,[act_area] [text] COLLATE Chinese_PRC_CI_AS NULL ,[tel] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,[cell] [char] (11) COLLATE Chinese_PRC_CI_AS NULL ,[fax] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,[ccontent] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,[bank] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,[bank_num] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,[zz_num] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,[tax_num] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,[realmoney] [float] NULL ,[zz_years] [int] NULL ,[fz_date] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,[fz_jiguan] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,[hangye] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ) 343．企業(yè)初始投資表（pany_cstz）見(jiàn)表源程序：CREATE TABLE [dbo].[pany_cstz] ([ame] [char] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,[cz_pro] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,[cz_money] [real] NULL ,[cz_man] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,[cz_code] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,[cz_date] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,[cz_percent] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,[extra] [char] (60) COLLATE Chinese_PRC_CI_AS NULL ) 4．交易總表(contract_total)建表源程序：CREATE TABLE [dbo].[contract_total] ([y] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,[m] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,[d] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,[gname] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,[gtax_num] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,[g_add] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,[gbank_num] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,[obj_bh] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,[obj_name] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,[obj_dw] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,[obj_sl] [int] NULL ,[obj_dj] [real] NULL ,[jine] [float] NULL ,[tax_per] [decimal](18, 0) NULL ,[taxe] [float] NULL ,[jshj] [float] NULL ,[xname] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,[xtax_num] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,[x_add] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,[xbank_num] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,[zj_years] [int] NULL ,[zj_idear] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,[canzhi] [float] NULL ,[pz_num] [int] NULL ,[zy] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ) 355．科目表(kmb) 建表源程序 ：CREATE TABLE [dbo].[kmb] ([km_num] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,[km_name] [char] (26) COLLATE Chinese_PRC_CI_AS NULL ,[km_xzh] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,[jdfx] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,[km_jb] [int] NULL ) 6．記賬憑證表(jzpz) 建表源程序：CREATE TABLE [dbo].[jzpz] ([y] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,[m] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,[d] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,[pz_num] [int] NULL ,[z_ame] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,[d_ame] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,[km_num] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,[km_name] [char] (26) COLLATE Chinese_PRC_CI_AS NULL ,[mxkm] [char] (26) COLLATE Chinese_PRC_CI_AS NULL ,[zy] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,[j_jine] [float] NULL ,[d_jine] [float] NULL ) 7．時(shí)間維表（time_dim）建表源程序：CREATE TABLE [dbo].[time_dim] ([time_num] [int] IDENTITY (1, 1) NOT NULL ,[y] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,[m] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,[d] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ) 8．貨物維表(obj_dim)建表源程序：CREATE TABLE [dbo].[obj_dim] ([obj_num] [int] IDENTITY (1, 1) NOT NULL ,[obj_bh] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,[obj_name] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[obj_dw] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,36[obj_dj] [real] NOT NULL ) 9．購(gòu)貨單位維表(g_dim)建表源程序：CREATE TABLE [dbo].[g_dim] ([g_num] [int] IDENTITY (1, 1) NOT NULL ,[gname] [char] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,[gtax_num] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,[g_add] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,[gbank_num] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ) 10．銷(xiāo)貨單位維表(x_dim)建表源程序：CREATE TABLE [dbo].[x_dim] ([x_num] [int] IDENTITY (1, 1) NOT NULL ,[xname] [char] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,[xtax_num] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,[x_add] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,[xbank_num] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ) 11．交易事實(shí)表(contract_total)建表源程序：CREATE TABLE [dbo].[contract_fact] ([s_num] [int] IDENTITY (1, 1) NOT NULL ,[g_num] [int] NOT NULL ,[x_num] [int] NOT NULL ,[time_num] [int] NOT NULL ,[obj_num] [int] NOT NULL ,[obj_sl] [int] NOT NULL ,[jine] [float] NOT NULL ,[tax_per] [decimal](18, 0) NOT NULL ,[taxe] [float] NOT NULL ,[jshj] [float] NOT NULL )