SQL Server 2000 Sample Databases.rar

  • k8_641554
    了解作者
  • 886.1KB
    文件大小
  • rar
    文件格式
  • 0
    收藏次数
  • VIP专享
    资源类型
  • 0
    下载次数
  • 2022-05-26 10:05
    上传日期
SQL Server 2000 Sample Databases.rar,这个不用讲了是微软数据库带的两例子数据库,特意放上来,给有需要的人
SQLServerSampleDatabases.rar
  • PUBS_LOG.LDF
    768KB
  • ReadMe_SQL2000SampleDbScripts.htm
    60.1KB
  • NORTHWND.MDF
    2.6MB
  • PUBS.MDF
    1.3MB
  • instpubs.sql
    125.5KB
  • instnwnd.sql
    2MB
  • NORTHWND.LDF
    1MB
内容介绍
/* ** Copyright Microsoft, Inc. 1994 - 2000 ** All Rights Reserved. */ SET NOCOUNT ON GO USE master GO if exists (select * from sysdatabases where name='Northwind') drop database Northwind go DECLARE @device_directory NVARCHAR(520) SELECT @device_directory = SUBSTRING(filename, 1, CHARINDEX(N'master.mdf', LOWER(filename)) - 1) FROM master.dbo.sysaltfiles WHERE dbid = 1 AND fileid = 1 EXECUTE (N'CREATE DATABASE Northwind ON PRIMARY (NAME = N''Northwind'', FILENAME = N''' + @device_directory + N'northwnd.mdf'') LOG ON (NAME = N''Northwind_log'', FILENAME = N''' + @device_directory + N'northwnd.ldf'')') go exec sp_dboption 'Northwind','trunc. log on chkpt.','true' exec sp_dboption 'Northwind','select into/bulkcopy','true' GO set quoted_identifier on GO /* Set DATEFORMAT so that the date strings are interpreted correctly regardless of the default DATEFORMAT on the server. */ SET DATEFORMAT mdy GO use "Northwind" go if exists (select * from sysobjects where id = object_id('dbo.Employee Sales by Country') and sysstat & 0xf = 4) drop procedure "dbo"."Employee Sales by Country" GO if exists (select * from sysobjects where id = object_id('dbo.Sales by Year') and sysstat & 0xf = 4) drop procedure "dbo"."Sales by Year" GO if exists (select * from sysobjects where id = object_id('dbo.Ten Most Expensive Products') and sysstat & 0xf = 4) drop procedure "dbo"."Ten Most Expensive Products" GO if exists (select * from sysobjects where id = object_id('dbo.Category Sales for 1997') and sysstat & 0xf = 2) drop view "dbo"."Category Sales for 1997" GO if exists (select * from sysobjects where id = object_id('dbo.Sales by Category') and sysstat & 0xf = 2) drop view "dbo"."Sales by Category" GO if exists (select * from sysobjects where id = object_id('dbo.Sales Totals by Amount') and sysstat & 0xf = 2) drop view "dbo"."Sales Totals by Amount" GO if exists (select * from sysobjects where id = object_id('dbo.Summary of Sales by Quarter') and sysstat & 0xf = 2) drop view "dbo"."Summary of Sales by Quarter" GO if exists (select * from sysobjects where id = object_id('dbo.Summary of Sales by Year') and sysstat & 0xf = 2) drop view "dbo"."Summary of Sales by Year" GO if exists (select * from sysobjects where id = object_id('dbo.Invoices') and sysstat & 0xf = 2) drop view "dbo"."Invoices" GO if exists (select * from sysobjects where id = object_id('dbo.Order Details Extended') and sysstat & 0xf = 2) drop view "dbo"."Order Details Extended" GO if exists (select * from sysobjects where id = object_id('dbo.Order Subtotals') and sysstat & 0xf = 2) drop view "dbo"."Order Subtotals" GO if exists (select * from sysobjects where id = object_id('dbo.Product Sales for 1997') and sysstat & 0xf = 2) drop view "dbo"."Product Sales for 1997" GO if exists (select * from sysobjects where id = object_id('dbo.Alphabetical list of products') and sysstat & 0xf = 2) drop view "dbo"."Alphabetical list of products" GO if exists (select * from sysobjects where id = object_id('dbo.Current Product List') and sysstat & 0xf = 2) drop view "dbo"."Current Product List" GO if exists (select * from sysobjects where id = object_id('dbo.Orders Qry') and sysstat & 0xf = 2) drop view "dbo"."Orders Qry" GO if exists (select * from sysobjects where id = object_id('dbo.Products Above Average Price') and sysstat & 0xf = 2) drop view "dbo"."Products Above Average Price" GO if exists (select * from sysobjects where id = object_id('dbo.Products by Category') and sysstat & 0xf = 2) drop view "dbo"."Products by Category" GO if exists (select * from sysobjects where id = object_id('dbo.Quarterly Orders') and sysstat & 0xf = 2) drop view "dbo"."Quarterly Orders" GO if exists (select * from sysobjects where id = object_id('dbo.Customer and Suppliers by City') and sysstat & 0xf = 2) drop view "dbo"."Customer and Suppliers by City" GO if exists (select * from sysobjects where i�
评论
    相关推荐