【正文】 nes = 3 Configuration = (H (1 [50] 4 [25] 3)) End Begin PaneConfiguration = 2 NumPanes = 3 Configuration = (H (1 [50] 2 [25] 3)) End Begin PaneConfiguration = 3 NumPanes = 3 Configuration = (H (4 [30] 2 [40] 3)) End Begin PaneConfiguration = 4 NumPanes = 2 Configuration = (H (1 [56] 3)) End Begin PaneConfiguration = 5 NumPanes = 2 Configuration = (H (2 [66] 3)) End Begin PaneConfiguration = 6 NumPanes = 2 Configuration = (H (4 [50] 3)) End Begin PaneConfiguration = 7 NumPanes = 1 Configuration = (V (3)) End Begin PaneConfiguration = 8 NumPanes = 3 Configuration = (H (1[56] 4[18] 2) ) End Begin PaneConfiguration = 9 NumPanes = 2 Configuration = (H (1 [75] 4)) End Begin PaneConfiguration = 10 NumPanes = 2 Configuration = (H (1[66] 2) ) End Begin PaneConfiguration = 11 NumPanes = 2 Configuration = (H (4 [60] 2)) End Begin PaneConfiguration = 12 NumPanes = 1 Configuration = (H (1) ) End Begin PaneConfiguration = 13 NumPanes = 1 Configuration = (V (4)) End Begin PaneConfiguration = 14 NumPanes = 1 Configuration = (V (2)) End ActivePaneConfig = 0 End Begin DiagramPane = Begin Origin = Top = 0 Left = 0 End Begin Tables = Begin Table = 基本檔案 Begin Extent = Top = 6 Left = 38 Bottom = 116 Right = 179 End DisplayFlags = 280 TopColumn = 0 End End End Begin SQLPane = End Begin DataPane = Begin ParameterDefaults = End End Begin CriteriaPane = Begin ColumnWidths = 11 Column = 1440 Alias = 900 Table = 1170 Output = 720 Append = 1400 NewValue = 1170 SortType = 1350 SortOrder = 1410 GroupBy = 1350 Filter = 1350 Or = 1350 Or = 1350 Or = 1350 End EndEnd39。 ,@level0type=N39。SCHEMA39。, @level0name=N39。dbo39。, @level1type=N39。VIEW39。, @level1name=N39?？捎脟?guó)有資產(chǎn)視圖39。GOEXEC @name=N39。MS_DiagramPaneCount39。, @value=1 ,@level0type=N39。SCHEMA39。, @level0name=N39。dbo39。, @level1type=N39。VIEW39。, @level1name=N39?？捎脟?guó)有資產(chǎn)視圖39。 累計(jì)折舊查詢視圖設(shè)計(jì) [累計(jì)折舊查詢]視圖用于查詢?cè)露扔?jì)提的國(guó)有資產(chǎn)折舊信息。創(chuàng)建[累計(jì)折舊查詢]視圖的SQL腳本文件的內(nèi)容如下：USE [MyAssetsDB]GO/****** 對(duì)象: View [dbo].[累計(jì)折舊查詢視圖] 腳本日期: 05/19/2007 10:57:29 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE VIEW [dbo].[累計(jì)折舊查詢視圖]ASSELECT TOP (100) PERCENT , , , , , , , , FROM INNER JOIN ON = ORDER BY , , GOEXEC @name=N39。MS_DiagramPane139。, @value=N39。[0E232FF0B46611cfA24F00AA00A3EFFF, ]Begin DesignProperties = Begin PaneConfigurations = Begin PaneConfiguration = 0 NumPanes = 4 Configuration = (H (1[40] 4[20] 2[20] 3) ) End Begin PaneConfiguration = 1 NumPanes = 3 Configuration = (H (1 [50] 4 [25] 3)) End Begin PaneConfiguration = 2 NumPanes = 3 Configuration = (H (1 [50] 2 [25] 3)) End Begin PaneConfiguration = 3 NumPanes = 3 Configuration = (H (4 [30] 2 [40] 3)) End Begin PaneConfiguration = 4 NumPanes = 2 Configuration = (H (1 [56] 3)) End Begin PaneConfiguration = 5 NumPanes = 2 Configuration = (H (2 [66] 3)) End Begin PaneConfiguration = 6 NumPanes = 2 Configuration = (H (4 [50] 3)) End Begin PaneConfiguration = 7 NumPanes = 1 Configuration = (V (3)) End Begin PaneConfiguration = 8 NumPanes = 3 Configuration = (H (1[56] 4[18] 2) ) End Begin PaneConfiguration = 9 NumPanes = 2 Configuration = (H (1 [75] 4)) End Begin PaneConfiguration = 10 NumPanes = 2 Configuration = (H (1[66] 2) ) End Begin PaneConfiguration = 11 NumPanes = 2 Configuration = (H (4 [60] 2)) End Begin PaneConfiguration = 12 NumPanes = 1 Configuration = (H (1) ) End Begin PaneConfiguration = 13 NumPanes = 1 Configuration = (V (4)) End Begin PaneConfiguration = 14 NumPanes = 1 Configuration = (V (2)) End ActivePaneConfig = 0 End Begin DiagramPane = Begin Origin = Top = 0 Left = 0 End Begin Tables = Begin Table = 基本檔案 Begin Extent = Top = 6 Left = 38 Bottom = 223 Right = 179 End DisplayFlags = 280 TopColumn = 0 End Begin Table = 累計(jì)折舊表 Begin Extent = Top = 6 Left = 217 Bottom = 219 Right = 358 End DisplayFlags = 280 TopColumn = 0 End End End Begin SQLPane = End Begin DataPane = Begin ParameterDefaults = End End Begin CriteriaPane = Begin ColumnWidths = 11 Column = 1440 Alias = 900 Table = 1170 Output = 720 Append = 1400 NewValue = 1170 SortType = 1350 SortOrder = 1410 GroupBy = 1350 Filter = 1350 Or = 1350