在线订餐系统源码-问答列表|—51aspx.com

51asp***（编辑）回复于：2008-07-25 11:49:00

Sql2000格式数据库的Sql语句，在Sql2000下运行即可<div class="blockcode"><div id="code_-1"><ol><li> </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UT_Role]') AND type in (N'U')) </li> <li>BEGIN </li> <li>CREATE TABLE [dbo].[UT_Role]( </li> <li> [SystemId] [bigint] IDENTITY(1,1) NOT NULL, </li> <li> [RoleName] [varchar](50) NOT NULL, </li> <li> [Power] [tinyint] NOT NULL CONSTRAINT [DF_UT_Role_Power]  DEFAULT ((1)), </li> <li> CONSTRAINT [PK_UT_Role] PRIMARY KEY CLUSTERED </li> <li>( </li> <li> [SystemId] ASC </li> <li>)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY] </li> <li>) ON [PRIMARY] </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UT_Reward]') AND type in (N'U')) </li> <li>BEGIN </li> <li>CREATE TABLE [dbo].[UT_Reward]( </li> <li> [GUID] [uniqueidentifier] NOT NULL, </li> <li> [Reward] [bigint] NOT NULL CONSTRAINT [DF_UT_Reward_Reward]  DEFAULT ((0)), </li> <li> CONSTRAINT [PK_UT_Reward] PRIMARY KEY CLUSTERED </li> <li>( </li> <li> [GUID] ASC </li> <li>)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY] </li> <li>) ON [PRIMARY] </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UT_ItemType]') AND type in (N'U')) </li> <li>BEGIN </li> <li>CREATE TABLE [dbo].[UT_ItemType]( </li> <li> [ItemTypeId] [bigint] IDENTITY(1,1) NOT NULL, </li> <li> [TypeName] [varchar](50) NOT NULL, </li> <li> CONSTRAINT [PK_UT_ItemType] PRIMARY KEY CLUSTERED </li> <li>( </li> <li> [ItemTypeId] ASC </li> <li>)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY] </li> <li>) ON [PRIMARY] </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UT_Menu]') AND type in (N'U')) </li> <li>BEGIN </li> <li>CREATE TABLE [dbo].[UT_Menu]( </li> <li> [MeunId] [uniqueidentifier] NOT NULL, </li> <li> [MenuItems] [bigint] NOT NULL </li> <li>) ON [PRIMARY] </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UT_Order]') AND type in (N'U')) </li> <li>BEGIN </li> <li>CREATE TABLE [dbo].[UT_Order]( </li> <li> [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL, </li> <li> [MenuId] [uniqueidentifier] NOT NULL, </li> <li> [Number] [smallint] NOT NULL, </li> <li> [LoginName] [varchar](50) NOT NULL, </li> <li> [ActionTime] [datetime] NOT NULL, </li> <li> [Mark] [varchar](500) NULL, </li> <li> [State] [char](1) NOT NULL CONSTRAINT [DF_UT_Order_State]  DEFAULT ((0)), </li> <li> CONSTRAINT [PK_UT_Order] PRIMARY KEY CLUSTERED </li> <li>( </li> <li> [GUID] ASC </li> <li>)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY] </li> <li>) ON [PRIMARY] </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UT_News]') AND type in (N'U')) </li> <li>BEGIN </li> <li>CREATE TABLE [dbo].[UT_News]( </li> <li> [SystemId] [bigint] IDENTITY(1,1) NOT NULL, </li> <li> [Title] [varchar](50) NOT NULL, </li> <li> [Context] [varchar](max) NOT NULL, </li> <li> [PublishTime] [datetime] NOT NULL CONSTRAINT [DF_UT_News_PublishTime]  DEFAULT (getdate()), </li> <li> CONSTRAINT [PK_UT_News] PRIMARY KEY CLUSTERED </li> <li>( </li> <li> [SystemId] ASC </li> <li>)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY] </li> <li>) ON [PRIMARY] </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UT_Items]') AND type in (N'U')) </li> <li>BEGIN </li> <li>CREATE TABLE [dbo].[UT_Items]( </li> <li> [SystemId] [bigint] IDENTITY(1,1) NOT NULL, </li> <li> [ItemsName] [varchar](50) NOT NULL, </li> <li> [Price] [numeric](6, 2) NULL CONSTRAINT [DF_UT_Items_Price]  DEFAULT ((0.0)), </li> <li> [Type] [bigint] NOT NULL, </li> <li> [Pic] [varchar](100) NULL, </li> <li> [Detail] [varchar](500) NULL, </li> <li> CONSTRAINT [PK_UT_Items] PRIMARY KEY CLUSTERED </li> <li>( </li> <li> [SystemId] ASC </li> <li>)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY] </li> <li>) ON [PRIMARY] </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UT_User]') AND type in (N'U')) </li> <li>BEGIN </li> <li>CREATE TABLE [dbo].[UT_User]( </li> <li> [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_UT_User_GUID]  DEFAULT (newid()), </li> <li> [LoginName] [varchar](50) NOT NULL, </li> <li> [Pwd] [varchar](50) NOT NULL, </li> <li> [Sex] [char](1) NOT NULL, </li> <li> [DisPlayName] [varchar](50) NULL, </li> <li> [Mark] [varchar](500) NULL, </li> <li> [Contact] [varchar](50) NOT NULL, </li> <li> [Tel] [varchar](50) NOT NULL, </li> <li> [Group] [int] NOT NULL CONSTRAINT [DF_UT_User_Group]  DEFAULT ((0)), </li> <li> CONSTRAINT [PK_UT_User] PRIMARY KEY CLUSTERED </li> <li>( </li> <li> [LoginName] ASC </li> <li>)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY] </li> <li>) ON [PRIMARY] </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UT_MenuType]') AND type in (N'U')) </li> <li>BEGIN </li> <li>CREATE TABLE [dbo].[UT_MenuType]( </li> <li> [MenuId] [uniqueidentifier] ROWGUIDCOL  NOT NULL, </li> <li> [MenuName] [varchar](50) NOT NULL, </li> <li> [Type] [char](1) NOT NULL, </li> <li> [CreaterId] [varchar](50) NOT NULL, </li> <li> [CreateTime] [datetime] NOT NULL CONSTRAINT [DF_UT_MenuType_CreateTime]  DEFAULT (getdate()), </li> <li> [Detail] [varchar](500) NULL, </li> <li> CONSTRAINT [PK_UT_MenuType] PRIMARY KEY CLUSTERED </li> <li>( </li> <li> [MenuId] ASC </li> <li>)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY] </li> <li>) ON [PRIMARY] </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UT_ItemMsg]') AND type in (N'U')) </li> <li>BEGIN </li> <li>CREATE TABLE [dbo].[UT_ItemMsg]( </li> <li> [SystemId] [bigint] IDENTITY(1,1) NOT NULL, </li> <li> [ItemsId] [bigint] NOT NULL, </li> <li> [UserName] [varchar](50) NOT NULL, </li> <li> [Commment] [varchar](500) NULL, </li> <li> [UserIp] [varchar](50) NOT NULL, </li> <li> [Date] [datetime] NULL CONSTRAINT [DF_UT_ItemMsg_Date]  DEFAULT (getdate()), </li> <li> CONSTRAINT [PK_UT_ItemMsg] PRIMARY KEY CLUSTERED </li> <li>( </li> <li> [SystemId] ASC </li> <li>)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY] </li> <li>) ON [PRIMARY] </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UT_Login]') AND type in (N'U')) </li> <li>BEGIN </li> <li>CREATE TABLE [dbo].[UT_Login]( </li> <li> [SystemId] [bigint] IDENTITY(1,1) NOT NULL, </li> <li> [UserGuid] [uniqueidentifier] NOT NULL, </li> <li> [LoginTime] [datetime] NOT NULL CONSTRAINT [DF_UT_Login_LoginTime]  DEFAULT (getdate()), </li> <li> [ReTurnGuid] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_UT_Login_ReTurnGuid]  DEFAULT (newid()), </li> <li> CONSTRAINT [PK_UT_Login] PRIMARY KEY CLUSTERED </li> <li>( </li> <li> [UserGuid] ASC </li> <li>)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY] </li> <li>) ON [PRIMARY] </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[UV_ActiveUser]')) </li> <li>EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[UV_ActiveUser] </li> <li>AS </li> <li>SELECT dbo.UT_User.GUID, dbo.UT_User.LoginName, dbo.UT_User.Pwd, </li> <li>      dbo.UT_User.Sex, dbo.UT_User.DisPlayName, dbo.UT_User.Mark, </li> <li>      dbo.UT_User.Contact, dbo.UT_User.Tel, dbo.UT_User.[Group], </li> <li>      dbo.UT_Reward.Reward </li> <li>FROM dbo.UT_User LEFT OUTER JOIN </li> <li>      dbo.UT_Reward ON dbo.UT_User.GUID = dbo.UT_Reward.GUID </li> <li>WHERE (dbo.UT_User.LoginName IN </li> <li>          (SELECT LoginName </li> <li>         FROM (SELECT TOP (2) COUNT(LoginName) AS sumUser, LoginName </li> <li>                 FROM dbo.UT_Order </li> <li>                 GROUP BY LoginName </li> <li>                 ORDER BY sumUser DESC) AS derivedtbl_1)) </li> <li>' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'UV_ActiveUser', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00] </li> <li>Begin DesignProperties = </li> <li>   Begin PaneConfigurations = </li> <li>      Begin PaneConfiguration = 0 </li> <li>         NumPanes = 4 </li> <li>         Configuration = "(H (1[40] 4[20] 2[20] 3) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 1 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 4 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 2 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 2 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 3 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (4 [30] 2 [40] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 4 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [56] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 5 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (2 [66] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 6 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [50] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 7 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 8 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1[56] 4[18] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 9 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [75] 4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 10 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1[66] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 11 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [60] 2))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 12 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(H (1) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 13 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 14 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (2))" </li> <li>      End </li> <li>      ActivePaneConfig = 0 </li> <li>   End </li> <li>   Begin DiagramPane = </li> <li>      Begin Origin = </li> <li>         Top = 0 </li> <li>         Left = 0 </li> <li>      End </li> <li>      Begin Tables = </li> <li>         Begin Table = "UT_User" </li> <li>            Begin Extent = </li> <li>               Top = 6 </li> <li>               Left = 38 </li> <li>               Bottom = 109 </li> <li>               Right = 184 </li> <li>            End </li> <li>            DisplayFlags = 280 </li> <li>            TopColumn = 0 </li> <li>         End </li> <li>         Begin Table = "UT_Reward" </li> <li>            Begin Extent = </li> <li>               Top = 6 </li> <li>               Left = 222 </li> <li>               Bottom = 81 </li> <li>               Right = 356 </li> <li>            End </li> <li>            DisplayFlags = 280 </li> <li>            TopColumn = 0 </li> <li>         End </li> <li>      End </li> <li>   End </li> <li>   Begin SQLPane = </li> <li>   End </li> <li>   Begin DataPane = </li> <li>      Begin ParameterDefaults = "" </li> <li>      End </li> <li>      Begin ColumnWidths = 10 </li> <li>         Width = 284 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>      End </li> <li>   End </li> <li>   Begin CriteriaPane = </li> <li>      Begin ColumnWidths = 11 </li> <li>         Column = 1440 </li> <li>         Alias = 900 </li> <li>         Table = 1170 </li> <li>         Output = 720 </li> <li>         Append = 1400 </li> <li>         NewValue = 1170 </li> <li>         SortType = 1350 </li> <li>         SortOrder = 1410 </li> <li>         GroupBy = 1350 </li> <li>         Filter = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>      End </li> <li>   End </li> <li>End </li> <li>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'UV_ActiveUser' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'UV_ActiveUser', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'UV_ActiveUser' </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[UV_Items]')) </li> <li>EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[UV_Items] </li> <li>AS </li> <li>SELECT dbo.UT_Items.SystemId, dbo.UT_Items.ItemsName, dbo.UT_Items.Pic, </li> <li>      dbo.UT_Items.Detail, dbo.UT_ItemType.TypeName </li> <li>FROM dbo.UT_Items INNER JOIN </li> <li>      dbo.UT_ItemType ON dbo.UT_Items.Type = dbo.UT_ItemType.ItemTypeId </li> <li>' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'UV_Items', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00] </li> <li>Begin DesignProperties = </li> <li>   Begin PaneConfigurations = </li> <li>      Begin PaneConfiguration = 0 </li> <li>         NumPanes = 4 </li> <li>         Configuration = "(H (1[40] 4[20] 2[20] 3) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 1 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 4 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 2 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 2 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 3 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (4 [30] 2 [40] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 4 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [56] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 5 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (2 [66] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 6 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [50] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 7 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 8 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1[56] 4[18] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 9 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [75] 4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 10 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1[66] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 11 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [60] 2))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 12 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(H (1) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 13 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 14 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (2))" </li> <li>      End </li> <li>      ActivePaneConfig = 0 </li> <li>   End </li> <li>   Begin DiagramPane = </li> <li>      Begin Origin = </li> <li>         Top = 0 </li> <li>         Left = 0 </li> <li>      End </li> <li>      Begin Tables = </li> <li>         Begin Table = "UT_Items" </li> <li>            Begin Extent = </li> <li>               Top = 6 </li> <li>               Left = 38 </li> <li>               Bottom = 116 </li> <li>               Right = 173 </li> <li>            End </li> <li>            DisplayFlags = 280 </li> <li>            TopColumn = 2 </li> <li>         End </li> <li>         Begin Table = "UT_ItemType" </li> <li>            Begin Extent = </li> <li>               Top = 6 </li> <li>               Left = 211 </li> <li>               Bottom = 88 </li> <li>               Right = 352 </li> <li>            End </li> <li>            DisplayFlags = 280 </li> <li>            TopColumn = 0 </li> <li>         End </li> <li>      End </li> <li>   End </li> <li>   Begin SQLPane = </li> <li>   End </li> <li>   Begin DataPane = </li> <li>      Begin ParameterDefaults = "" </li> <li>      End </li> <li>      Begin ColumnWidths = 9 </li> <li>         Width = 284 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>      End </li> <li>   End </li> <li>   Begin CriteriaPane = </li> <li>      Begin ColumnWidths = 11 </li> <li>         Column = 2145 </li> <li>         Alias = 900 </li> <li>         Table = 1170 </li> <li>         Output = 720 </li> <li>         Append = 1400 </li> <li>         NewValue = 1170 </li> <li>         SortType = 1350 </li> <li>         SortOrder = 1410 </li> <li>         GroupBy = 1350 </li> <li>         Filter = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>      End </li> <li>   End </li> <li>End </li> <li>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'UV_Items' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'UV_Items', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'UV_Items' </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[UV_Menu]')) </li> <li>EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[UV_Menu] </li> <li>AS </li> <li>SELECT dbo.UT_MenuType.MenuId, dbo.UT_MenuType.MenuName, </li> <li>      dbo.UT_MenuType.Type, dbo.UT_MenuType.Detail, dbo.UT_MenuType.CreaterId, </li> <li>      dbo.UT_MenuType.CreateTime, dbo.UT_Items.ItemsName, dbo.UT_Items.Price, </li> <li>      dbo.UT_Items.Type AS ItemType, dbo.UT_Items.Pic, </li> <li>      dbo.UT_Items.Detail AS ItemDetail, dbo.UT_Items.SystemId </li> <li>FROM dbo.UT_Items INNER JOIN </li> <li>      dbo.UT_Menu ON dbo.UT_Items.SystemId = dbo.UT_Menu.MenuItems INNER JOIN </li> <li>      dbo.UT_MenuType ON dbo.UT_Menu.MeunId = dbo.UT_MenuType.MenuId </li> <li>' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'UV_Menu', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00] </li> <li>Begin DesignProperties = </li> <li>   Begin PaneConfigurations = </li> <li>      Begin PaneConfiguration = 0 </li> <li>         NumPanes = 4 </li> <li>         Configuration = "(H (1[40] 4[20] 2[20] 3) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 1 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 4 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 2 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 2 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 3 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (4 [30] 2 [40] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 4 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [56] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 5 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (2 [66] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 6 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [50] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 7 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 8 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1[56] 4[18] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 9 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [75] 4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 10 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1[66] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 11 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [60] 2))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 12 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(H (1) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 13 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 14 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (2))" </li> <li>      End </li> <li>      ActivePaneConfig = 0 </li> <li>   End </li> <li>   Begin DiagramPane = </li> <li>      Begin Origin = </li> <li>         Top = 0 </li> <li>         Left = 0 </li> <li>      End </li> <li>      Begin Tables = </li> <li>         Begin Table = "UT_Items" </li> <li>            Begin Extent = </li> <li>               Top = 64 </li> <li>               Left = 454 </li> <li>               Bottom = 167 </li> <li>               Right = 588 </li> <li>            End </li> <li>            DisplayFlags = 280 </li> <li>            TopColumn = 0 </li> <li>         End </li> <li>         Begin Table = "UT_Menu" </li> <li>            Begin Extent = </li> <li>               Top = 6 </li> <li>               Left = 216 </li> <li>               Bottom = 81 </li> <li>               Right = 350 </li> <li>            End </li> <li>            DisplayFlags = 280 </li> <li>            TopColumn = 0 </li> <li>         End </li> <li>         Begin Table = "UT_MenuType" </li> <li>            Begin Extent = </li> <li>               Top = 6 </li> <li>               Left = 38 </li> <li>               Bottom = 109 </li> <li>               Right = 178 </li> <li>            End </li> <li>            DisplayFlags = 280 </li> <li>            TopColumn = 0 </li> <li>         End </li> <li>      End </li> <li>   End </li> <li>   Begin SQLPane = </li> <li>   End </li> <li>   Begin DataPane = </li> <li>      Begin ParameterDefaults = "" </li> <li>      End </li> <li>      Begin ColumnWidths = 12 </li> <li>         Width = 284 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>      End </li> <li>   End </li> <li>   Begin CriteriaPane = </li> <li>      Begin ColumnWidths = 11 </li> <li>         Column = 2520 </li> <li>         Alias = 900 </li> <li>         Table = 1170 </li> <li>         Output = 720 </li> <li>         Append = 1400 </li> <li>         NewValue = 1170 </li> <li>         SortType = 1350 </li> <li>         SortOrder = 1410 </li> <li>         GroupBy = 1350 </li> <li>         Filter = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>      End </li> <li>   End </li> <li>End </li> <li>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'UV_Menu' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'UV_Menu', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'UV_Menu' </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[UV_HotMenu]')) </li> <li>EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[UV_HotMenu] </li> <li>AS </li> <li>SELECT MenuId </li> <li>FROM (SELECT TOP (2) COUNT(MenuId) AS Expr1, MenuId </li> <li>        FROM dbo.UT_Order </li> <li>        GROUP BY MenuId </li> <li>        ORDER BY Expr1 DESC) AS derivedtbl_1 </li> <li>' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'UV_HotMenu', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00] </li> <li>Begin DesignProperties = </li> <li>   Begin PaneConfigurations = </li> <li>      Begin PaneConfiguration = 0 </li> <li>         NumPanes = 4 </li> <li>         Configuration = "(H (1[40] 4[20] 2[20] 3) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 1 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 4 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 2 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 2 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 3 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (4 [30] 2 [40] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 4 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [56] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 5 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (2 [66] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 6 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [50] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 7 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 8 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1[56] 4[18] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 9 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [75] 4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 10 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1[66] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 11 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [60] 2))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 12 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(H (1) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 13 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 14 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (2))" </li> <li>      End </li> <li>      ActivePaneConfig = 0 </li> <li>   End </li> <li>   Begin DiagramPane = </li> <li>      Begin Origin = </li> <li>         Top = 0 </li> <li>         Left = 0 </li> <li>      End </li> <li>      Begin Tables = </li> <li>         Begin Table = "derivedtbl_1" </li> <li>            Begin Extent = </li> <li>               Top = 6 </li> <li>               Left = 38 </li> <li>               Bottom = 81 </li> <li>               Right = 172 </li> <li>            End </li> <li>            DisplayFlags = 280 </li> <li>            TopColumn = 0 </li> <li>         End </li> <li>      End </li> <li>   End </li> <li>   Begin SQLPane = </li> <li>   End </li> <li>   Begin DataPane = </li> <li>      Begin ParameterDefaults = "" </li> <li>      End </li> <li>      Begin ColumnWidths = 9 </li> <li>         Width = 284 </li> <li>         Width = 1500 </li> <li>         Width = 2640 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>      End </li> <li>   End </li> <li>   Begin CriteriaPane = </li> <li>      Begin ColumnWidths = 11 </li> <li>         Column = 1440 </li> <li>         Alias = 900 </li> <li>         Table = 1170 </li> <li>         Output = 720 </li> <li>         Append = 1400 </li> <li>         NewValue = 1170 </li> <li>         SortType = 1350 </li> <li>         SortOrder = 1410 </li> <li>         GroupBy = 1350 </li> <li>         Filter = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>      End </li> <li>   End </li> <li>End </li> <li>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'UV_HotMenu' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'UV_HotMenu', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'UV_HotMenu' </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SP_NewOrder]') AND type in (N'P', N'PC')) </li> <li>BEGIN </li> <li>EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[SP_NewOrder] </li> <li> ( </li> <li> @menuId varchar(50), </li> <li> @number int, </li> <li> @loginName varchar(50), </li> <li> @actionTime datetime, </li> <li> @mark varchar(500), </li> <li> @orderguid uniqueidentifier OUTPUT </li> <li> ) </li> <li>AS </li> <li>   set nocount on </li> <li>   begin </li> <li>    SELECT @orderguid=NEWID(); </li> <li>    INSERT INTO UT_Order([GUID],MenuId,Number,LoginName,ActionTime,Mark) VALUES(@orderguid,@menuId,@number,@loginName,@actionTime,@mark) </li> <li>   end </li> <li>' </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[UV_Order]')) </li> <li>EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[UV_Order] </li> <li>AS </li> <li>SELECT dbo.UT_Order.*, dbo.UT_MenuType.MenuName, dbo.UT_MenuType.Detail </li> <li>FROM dbo.UT_Order INNER JOIN </li> <li>      dbo.UT_MenuType ON dbo.UT_Order.MenuId = dbo.UT_MenuType.MenuId </li> <li>' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'UV_Order', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00] </li> <li>Begin DesignProperties = </li> <li>   Begin PaneConfigurations = </li> <li>      Begin PaneConfiguration = 0 </li> <li>         NumPanes = 4 </li> <li>         Configuration = "(H (1[36] 4[26] 2[20] 3) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 1 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 4 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 2 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 2 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 3 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (4 [30] 2 [40] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 4 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [56] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 5 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (2 [66] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 6 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [50] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 7 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 8 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1[56] 4[18] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 9 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [75] 4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 10 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1[66] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 11 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [60] 2))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 12 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(H (1) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 13 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 14 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (2))" </li> <li>      End </li> <li>      ActivePaneConfig = 0 </li> <li>   End </li> <li>   Begin DiagramPane = </li> <li>      Begin Origin = </li> <li>         Top = 0 </li> <li>         Left = 0 </li> <li>      End </li> <li>      Begin Tables = </li> <li>         Begin Table = "UT_Order" </li> <li>            Begin Extent = </li> <li>               Top = 6 </li> <li>               Left = 38 </li> <li>               Bottom = 116 </li> <li>               Right = 179 </li> <li>            End </li> <li>            DisplayFlags = 280 </li> <li>            TopColumn = 0 </li> <li>         End </li> <li>         Begin Table = "UT_MenuType" </li> <li>            Begin Extent = </li> <li>               Top = 6 </li> <li>               Left = 217 </li> <li>               Bottom = 116 </li> <li>               Right = 358 </li> <li>            End </li> <li>            DisplayFlags = 280 </li> <li>            TopColumn = 0 </li> <li>         End </li> <li>      End </li> <li>   End </li> <li>   Begin SQLPane = </li> <li>   End </li> <li>   Begin DataPane = </li> <li>      Begin ParameterDefaults = "" </li> <li>      End </li> <li>   End </li> <li>   Begin CriteriaPane = </li> <li>      Begin ColumnWidths = 11 </li> <li>         Column = 1440 </li> <li>         Alias = 900 </li> <li>         Table = 1170 </li> <li>         Output = 720 </li> <li>         Append = 1400 </li> <li>         NewValue = 1170 </li> <li>         SortType = 1350 </li> <li>         SortOrder = 1410 </li> <li>         GroupBy = 1350 </li> <li>         Filter = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>      End </li> <li>   End </li> <li>End </li> <li>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'UV_Order' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'UV_Order', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'UV_Order' </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SP_AddMenuType]') AND type in (N'P', N'PC')) </li> <li>BEGIN </li> <li>EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[SP_AddMenuType] </li> <li> ( </li> <li> @MN varchar(50), </li> <li> @T char(1), </li> <li> @ID varchar(50), </li> <li> @D varchar(500), </li> <li> @MenuId uniqueidentifier OUTPUT </li> <li> ) </li> <li>AS </li> <li>   set nocount on </li> <li>   begin </li> <li>    SELECT @MenuId=NEWID(); </li> <li>    INSERT INTO UT_MenuType(MenuId,MenuName,Type,CreaterId,Detail) VALUES(@MenuId,@MN,@T,@ID,@D) </li> <li>   end </li> <li>' </li> <li>END </li> <li>GO </li> <li>SET ANSI_NULLS ON </li> <li>GO </li> <li>SET QUOTED_IDENTIFIER ON </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[UV_HotItems]')) </li> <li>EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[UV_HotItems] </li> <li>AS </li> <li>SELECT SystemId, ItemsName, Price, Type, Pic, Detail </li> <li>FROM dbo.UT_Items </li> <li>WHERE (SystemId IN </li> <li>          (SELECT SystemId </li> <li>         FROM (SELECT TOP (2) COUNT(SystemId) AS Expr1, SystemId </li> <li>                 FROM dbo.UV_Menu </li> <li>                 GROUP BY SystemId </li> <li>                 ORDER BY Expr1 DESC) AS derivedtbl_1)) </li> <li>' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPane1' , N'SCHEMA',N'dbo', N'VIEW',N'UV_HotItems', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00] </li> <li>Begin DesignProperties = </li> <li>   Begin PaneConfigurations = </li> <li>      Begin PaneConfiguration = 0 </li> <li>         NumPanes = 4 </li> <li>         Configuration = "(H (1[41] 4[21] 2[20] 3) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 1 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 4 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 2 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1 [50] 2 [25] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 3 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (4 [30] 2 [40] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 4 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [56] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 5 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (2 [66] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 6 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [50] 3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 7 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (3))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 8 </li> <li>         NumPanes = 3 </li> <li>         Configuration = "(H (1[56] 4[18] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 9 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1 [75] 4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 10 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (1[66] 2) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 11 </li> <li>         NumPanes = 2 </li> <li>         Configuration = "(H (4 [60] 2))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 12 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(H (1) )" </li> <li>      End </li> <li>      Begin PaneConfiguration = 13 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (4))" </li> <li>      End </li> <li>      Begin PaneConfiguration = 14 </li> <li>         NumPanes = 1 </li> <li>         Configuration = "(V (2))" </li> <li>      End </li> <li>      ActivePaneConfig = 0 </li> <li>   End </li> <li>   Begin DiagramPane = </li> <li>      Begin Origin = </li> <li>         Top = 0 </li> <li>         Left = 0 </li> <li>      End </li> <li>      Begin Tables = </li> <li>         Begin Table = "UT_Items" </li> <li>            Begin Extent = </li> <li>               Top = 6 </li> <li>               Left = 38 </li> <li>               Bottom = 109 </li> <li>               Right = 172 </li> <li>            End </li> <li>            DisplayFlags = 280 </li> <li>            TopColumn = 0 </li> <li>         End </li> <li>      End </li> <li>   End </li> <li>   Begin SQLPane = </li> <li>   End </li> <li>   Begin DataPane = </li> <li>      Begin ParameterDefaults = "" </li> <li>      End </li> <li>      Begin ColumnWidths = 9 </li> <li>         Width = 284 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>         Width = 1500 </li> <li>      End </li> <li>   End </li> <li>   Begin CriteriaPane = </li> <li>      Begin ColumnWidths = 11 </li> <li>         Column = 1440 </li> <li>         Alias = 900 </li> <li>         Table = 1170 </li> <li>         Output = 720 </li> <li>         Append = 1400 </li> <li>         NewValue = 1170 </li> <li>         SortType = 1350 </li> <li>         SortOrder = 1410 </li> <li>         GroupBy = 1350 </li> <li>         Filter = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>         Or = 1350 </li> <li>      End </li> <li>   End </li> <li>End </li> <li>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'UV_HotItems' </li> <li>GO </li> <li>IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_DiagramPaneCount' , N'SCHEMA',N'dbo', N'VIEW',N'UV_HotItems', NULL,NULL)) </li> <li>EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'UV_HotItems' </li> </ol></div>复制代码</div>

51asp***（编辑）回复于：2008-07-25 14:50:00

希望能对你有所帮助

sunbo***（用户）回复于：2008-07-30 11:59:00

谢谢谢谢谢谢谢谢谢谢

sunbo***（用户）回复于：2008-07-30 12:05:00

服务器: 消息 170，级别 15，状态 1，行 10 第 10 行: '(' 附近有语法错误。 服务器: 消息 170，级别 15，状态 1，行 9 第 9 行: '(' 附近有语法错误。 服务器: 消息 170，级别 15，状态 1，行 9 第 9 行: '(' 附近有语法错误。 服务器: 消息 208，级别 16，状态 1，行 1 对象名 'sys.objects' 无效。 服务器: 消息 170，级别 15，状态 1，行 14 第 14 行: '(' 附近有语法错误。 服务器: 消息 170，级别 15，状态 1，行 6 第 6 行: 'max' 附近有语法错误。 服务器: 消息 170，级别 15，状态 1，行 13 第 13 行: '(' 附近有语法错误。 服务器: 消息 170，级别 15，状态 1，行 16 第 16 行: '(' 附近有语法错误。 服务器: 消息 170，级别 15，状态 1，行 13 第 13 行: '(' 附近有语法错误。 服务器: 消息 170，级别 15，状态 1，行 13 第 13 行: '(' 附近有语法错误。 服务器: 消息 170，级别 15，状态 1，行 11 第 11 行: '(' 附近有语法错误。 服务器: 消息 208，级别 16，状态 1，行 1 对象名 'sys.views' 无效。 服务器: 消息 2812，级别 16，状态 62，行 2 未能找到存储过程 'sys.sp_addextendedproperty'。 服务器: 消息 2812，级别 16，状态 62，行 2 未能找到存储过程 'sys.sp_addextendedproperty'。 服务器: 消息 208，级别 16，状态 1，行 1 对象名 'sys.views' 无效。 服务器: 消息 2812，级别 16，状态 62，行 2 未能找到存储过程 'sys.sp_addextendedproperty'。 服务器: 消息 2812，级别 16，状态 62，行 2 未能找到存储过程 'sys.sp_addextendedproperty'。 服务器: 消息 208，级别 16，状态 1，行 1 对象名 'sys.views' 无效。 服务器: 消息 2812，级别 16，状态 62，行 2 未能找到存储过程 'sys.sp_addextendedproperty'。 服务器: 消息 2812，级别 16，状态 62，行 2 未能找到存储过程 'sys.sp_addextendedproperty'。 服务器: 消息 208，级别 16，状态 1，行 1 对象名 'sys.views' 无效。 服务器: 消息 2812，级别 16，状态 62，行 2 未能找到存储过程 'sys.sp_addextendedproperty'。 服务器: 消息 2812，级别 16，状态 62，行 2 未能找到存储过程 'sys.sp_addextendedproperty'。 服务器: 消息 208，级别 16，状态 1，行 1 对象名 'sys.objects' 无效。 服务器: 消息 208，级别 16，状态 1，行 1 对象名 'sys.views' 无效。 服务器: 消息 2812，级别 16，状态 62，行 2 未能找到存储过程 'sys.sp_addextendedproperty'。 服务器: 消息 2812，级别 16，状态 62，行 2 未能找到存储过程 'sys.sp_addextendedproperty'。 服务器: 消息 208，级别 16，状态 1，行 1 对象名 'sys.objects' 无效。 服务器: 消息 208，级别 16，状态 1，行 1 对象名 'sys.views' 无效。 服务器: 消息 2812，级别 16，状态 62，行 2 未能找到存储过程 'sys.sp_addextendedproperty'。 服务器: 消息 2812，级别 16，状态 62，行 2 未能找到存储过程 'sys.sp_addextendedproperty'。

源码信息

在线订餐系统源码

最新源码评论

综合讨论下载前咨询( 7 人) | 下载后讨论( 4 人 )

源码信息

在线订餐系统源码

最新源码评论

综合讨论 下载前咨询( 7 人) | 下载后讨论( 4 人 )

温馨提示

综合讨论下载前咨询( 7 人) | 下载后讨论( 4 人 )