朋友传给我的文件 我在查询分析器里面执行 显示有错误 代码如下:
CREATE DATABASE [db_GoodsManage] ON PRIMARY
( NAME = N'db_GoodsManage', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\db_GoodsManage.mdf' , SIZE = 2240KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'db_GoodsManage_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\db_GoodsManage_log.LDF' , SIZE = 560KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
COLLATE Chinese_PRC_CI_AS
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'db_GoodsManage', @new_cmptlevel=90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [db_GoodsManage].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [db_GoodsManage] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [db_GoodsManage] SET ANSI_NULLS OFF
GO
ALTER DATABASE [db_GoodsManage] SET ANSI_PADDING OFF
GO
ALTER DATABASE [db_GoodsManage] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [db_GoodsManage] SET ARITHABORT OFF
GO
ALTER DATABASE [db_GoodsManage] SET AUTO_CLOSE ON
GO
ALTER DATABASE [db_GoodsManage] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [db_GoodsManage] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [db_GoodsManage] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [db_GoodsManage] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [db_GoodsManage] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [db_GoodsManage] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [db_GoodsManage] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [db_GoodsManage] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [db_GoodsManage] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [db_GoodsManage] SET ENABLE_BROKER
GO
ALTER DATABASE [db_GoodsManage] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [db_GoodsManage] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [db_GoodsManage] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [db_GoodsManage] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [db_GoodsManage] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [db_GoodsManage] SET READ_WRITE
GO
ALTER DATABASE [db_GoodsManage] SET RECOVERY SIMPLE
GO
ALTER DATABASE [db_GoodsManage] SET MULTI_USER
GO
ALTER DATABASE [db_GoodsManage] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [db_GoodsManage] SET DB_CHAINING OFF
USE [db_GoodsManage]
GO
/****** 对象: Table [dbo].[tb_Goods] 脚本日期: 11/12/2009 17:03:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_Goods](
[GoodsID] [int] IDENTITY(1,1) NOT NULL,
[UserID] [int] NULL,
[CompanyName] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[DepotName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[GoodsName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[GoodsUnit] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[GoodsSpec] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[GoodsPrice] [decimal](18, 0) NULL,
[SellPrice] [decimal](18, 0) NULL,
[NeedPay] [decimal](18, 0) NULL,
[HasPay] [decimal](18, 0) NULL,
[Re] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NULL,
PRIMARY KEY CLUSTERED
(
[GoodsID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]USE [db_GoodsManage]
GO
/****** 对象: Table [dbo].[tb_ReGoods] 脚本日期: 11/12/2009 17:05:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_ReGoods](
[ReGoodsID] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL,
[StockID] [int] NULL,
[GoodsID] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[UserID] [int] NULL,
[CustomerID] [int] NULL,
[CompanyName] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[DepotName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ReGoodsName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ReGoodsNum] [int] NULL,
[ReGoodsTime] [datetime] NULL,
[ReGoodsSpec] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ReGoodsUnit] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ReGoodsPrice] [decimal](18, 0) NULL,
[NeedPay] [decimal](18, 0) NULL,
[HasPay] [decimal](18, 0) NULL,
[ReGoodsResult] [nvarchar](400) COLLATE Chinese_PRC_CI_AS NULL,
[ReGoodsSort] [int] NULL,
PRIMARY KEY CLUSTERED
(
[ReGoodsID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
USE [db_GoodsManage]
GO
/****** 对象: Table [dbo].[tb_Sell] 脚本日期: 11/12/2009 17:05:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_Sell](
[SellID] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL,
[StockID] [int] NULL,
[GoodsID] [int] NULL,
[UserID] [int] NULL,
[GoodsName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[GoodsSpec] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[GoodsTime] [datetime] NULL,
[GoodsUnit] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[GoodsPrice] [decimal](18, 0) NULL,
[SellPrice] [decimal](18, 0) NULL,
[NeedPay] [decimal](18, 0) NULL,
[HasPay] [decimal](18, 0) NULL,
[Re] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NULL,
PRIMARY KEY CLUSTERED
(
[SellID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
USE [db_GoodsManage]
GO
/****** 对象: Table [dbo].[tb_Stock] 脚本日期: 11/12/2009 17:05:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_Stock](
[StocksID] [int] IDENTITY(1,1) NOT NULL,
[GoodsID] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[CompanyName] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[DepotName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[StockNum] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[AlarmNum] [int] NULL,
[GoodsUnit] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[GoodsTime] [datetime] NULL,
[GoodsSpec] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[GoodsPrice] [decimal](18, 0) NULL,
[SellPrice] [decimal](18, 0) NULL,
[NeedPay] [decimal](18, 0) NULL,
[HasPay] [decimal](18, 0) NULL,
[Re] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NULL,
PRIMARY KEY CLUSTERED
(
[StocksID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
USE [db_GoodsManage]
GO
/****** 对象: Table [dbo].[tb_User] 脚本日期: 11/12/2009 17:05:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_User](
[UserID] [int] IDENTITY(1,1) NOT NULL,
[UserName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[SysLoginName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Pwd] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Sex] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Birthday] [datetime] NULL,
[Department] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Post] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[PhoneH] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[PhoneM] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Address] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NULL,
[PopedomID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[UserID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
CREATE DATABASE [db_GoodsManage] ON PRIMARY
( NAME = N'db_GoodsManage', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\db_GoodsManage.mdf' , SIZE = 2240KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'db_GoodsManage_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\db_GoodsManage_log.LDF' , SIZE = 560KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
COLLATE Chinese_PRC_CI_AS
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'db_GoodsManage', @new_cmptlevel=90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [db_GoodsManage].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [db_GoodsManage] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [db_GoodsManage] SET ANSI_NULLS OFF
GO
ALTER DATABASE [db_GoodsManage] SET ANSI_PADDING OFF
GO
ALTER DATABASE [db_GoodsManage] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [db_GoodsManage] SET ARITHABORT OFF
GO
ALTER DATABASE [db_GoodsManage] SET AUTO_CLOSE ON
GO
ALTER DATABASE [db_GoodsManage] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [db_GoodsManage] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [db_GoodsManage] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [db_GoodsManage] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [db_GoodsManage] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [db_GoodsManage] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [db_GoodsManage] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [db_GoodsManage] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [db_GoodsManage] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [db_GoodsManage] SET ENABLE_BROKER
GO
ALTER DATABASE [db_GoodsManage] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [db_GoodsManage] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [db_GoodsManage] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [db_GoodsManage] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [db_GoodsManage] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [db_GoodsManage] SET READ_WRITE
GO
ALTER DATABASE [db_GoodsManage] SET RECOVERY SIMPLE
GO
ALTER DATABASE [db_GoodsManage] SET MULTI_USER
GO
ALTER DATABASE [db_GoodsManage] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [db_GoodsManage] SET DB_CHAINING OFF
USE [db_GoodsManage]
GO
/****** 对象: Table [dbo].[tb_Goods] 脚本日期: 11/12/2009 17:03:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_Goods](
[GoodsID] [int] IDENTITY(1,1) NOT NULL,
[UserID] [int] NULL,
[CompanyName] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[DepotName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[GoodsName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[GoodsUnit] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[GoodsSpec] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[GoodsPrice] [decimal](18, 0) NULL,
[SellPrice] [decimal](18, 0) NULL,
[NeedPay] [decimal](18, 0) NULL,
[HasPay] [decimal](18, 0) NULL,
[Re] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NULL,
PRIMARY KEY CLUSTERED
(
[GoodsID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]USE [db_GoodsManage]
GO
/****** 对象: Table [dbo].[tb_ReGoods] 脚本日期: 11/12/2009 17:05:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_ReGoods](
[ReGoodsID] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL,
[StockID] [int] NULL,
[GoodsID] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[UserID] [int] NULL,
[CustomerID] [int] NULL,
[CompanyName] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[DepotName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ReGoodsName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ReGoodsNum] [int] NULL,
[ReGoodsTime] [datetime] NULL,
[ReGoodsSpec] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ReGoodsUnit] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ReGoodsPrice] [decimal](18, 0) NULL,
[NeedPay] [decimal](18, 0) NULL,
[HasPay] [decimal](18, 0) NULL,
[ReGoodsResult] [nvarchar](400) COLLATE Chinese_PRC_CI_AS NULL,
[ReGoodsSort] [int] NULL,
PRIMARY KEY CLUSTERED
(
[ReGoodsID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
USE [db_GoodsManage]
GO
/****** 对象: Table [dbo].[tb_Sell] 脚本日期: 11/12/2009 17:05:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_Sell](
[SellID] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL,
[StockID] [int] NULL,
[GoodsID] [int] NULL,
[UserID] [int] NULL,
[GoodsName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[GoodsSpec] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[GoodsTime] [datetime] NULL,
[GoodsUnit] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[GoodsPrice] [decimal](18, 0) NULL,
[SellPrice] [decimal](18, 0) NULL,
[NeedPay] [decimal](18, 0) NULL,
[HasPay] [decimal](18, 0) NULL,
[Re] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NULL,
PRIMARY KEY CLUSTERED
(
[SellID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
USE [db_GoodsManage]
GO
/****** 对象: Table [dbo].[tb_Stock] 脚本日期: 11/12/2009 17:05:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_Stock](
[StocksID] [int] IDENTITY(1,1) NOT NULL,
[GoodsID] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[CompanyName] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[DepotName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[StockNum] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[AlarmNum] [int] NULL,
[GoodsUnit] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[GoodsTime] [datetime] NULL,
[GoodsSpec] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[GoodsPrice] [decimal](18, 0) NULL,
[SellPrice] [decimal](18, 0) NULL,
[NeedPay] [decimal](18, 0) NULL,
[HasPay] [decimal](18, 0) NULL,
[Re] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NULL,
PRIMARY KEY CLUSTERED
(
[StocksID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
USE [db_GoodsManage]
GO
/****** 对象: Table [dbo].[tb_User] 脚本日期: 11/12/2009 17:05:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_User](
[UserID] [int] IDENTITY(1,1) NOT NULL,
[UserName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[SysLoginName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Pwd] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Sex] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Birthday] [datetime] NULL,
[Department] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Post] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[PhoneH] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[PhoneM] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Address] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NULL,
[PopedomID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[UserID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
2005转到2000的步骤步骤
1. 生成for 2000版本的数据库脚本
2005 的manger studio
-- 打开"对象资源管理器"(没有的话按F8), 连接到你的实例
-- 右键要转到2000的库
-- 任务
-- 生成脚本
-- 在"脚本向导"的"选择数据库"中, 确定选择的是要转到2000的库
-- 勾选"为所选数据库中的所有对象编写脚本"
-- 在接下来的"选择脚本选项"中, 找到"为服务器版本编写脚本"项, 选择"SQL Server 2000"
-- 其他选项根据需要设置
-- 最后把脚本保存到一个 .sql 脚本文件 2. 在2000中创建目标数据库
在查询分析器(或2005的manger studio在打开脚本文件), 连接到SQL Server 2000,执行上面生成的脚本.以创建一个新的数据库 3. 将数据从2005导到2000
2005 的manger studio
-- 打开"对象资源管理器"(没有的话按F8), 连接到你的实例
-- 右键要转到2000的库
-- 任务
-- 导出数据
-- 在"SQL Server 导入和导出向导"的"选择数据源"步骤中, 确定选择的是要导出的数据库
-- 在"选择目标"步骤中, 连接到 2000, 并选择步骤2新建的库
-- 在"选择源表和源视图"中, 选择所有的表
-- 最后完成
USE [db_GoodsManage] 之间的脚本单独执行