主题:  关于sqlserver的数据库

bzyum

职务:普通成员
等级:1
金币:1.0
发贴:167
注册:2001/11/24 22:11:43
#12003/3/6 22:35:41
我得到一个后缀名为sql的文件,用editplus打开一看,仿佛是一段构建sql数据库的代码,比如:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[apply]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[apply]
GO
CREATE TABLE [dbo].[apply] (
    [apply_id] [int] IDENTITY (1, 1) NOT NULL ,
    [user_id] [int] NULL ,
    [apply_type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [sex] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [number_id] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [oicq] [int] NULL ,
    [typerefid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [http] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [jingyan] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [yewu] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [youshi] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [fukuan] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [yijian] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [remark] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [balance] [int] NULL ,
    [dateandtime] [datetime] NULL ,
    [orgname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [zhiming] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [yingye] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [tel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [fax] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

请问能否运行这个文件构成一个sql数据库?



makdh

职务:普通成员
等级:1
金币:0.0
发贴:28
注册:2003/1/31 3:58:39
#22003/3/7 3:46:14
查询分析器建立DBO的APPLY表及相关字段