*.sql文件生成 sql server 7 的数据库时,*.sql需要选哪些选项?急:

[am2000]

IF ll_number>0 AND ll_number<=32765 THEN
trans_newBase.AutoCommit=True
EXECUTE IMMEDIATE:ls_sql Using trans_newBase;
IF trans_newBase.SqlCode=0 THEN
MessageBox("系统提示","数据表建立成功！")
ELSE
MessageBox("系统提示","数据表建立不成功！")
END IF
trans_newBase.AutoCommit=False
结果执行不成功,但当执行测试的sql语句又成功了.脚本大小小于<32765;
我的测试表结构为
create table mytemp(
field1 integer,
field2 integer
)
我生成数据库的脚本的时候应该选择哪些选项才能成功执行呢?我所导出的脚本在Query Analyzer中能正确执行.
请指点.谢谢!

[tiantianpb]

看看精华区的一篇文章对你或许有帮助

[am2000]

看了...

[am2000]

if exists (select * from sysobjects where id = object_id(N'[dbo].[dt_databasebackup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[dt_databasebackup]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[dt_databaserestore]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[dt_databaserestore]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[sp_BackRestore]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_BackRestore]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[sp_create_projectcode]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_create_projectcode]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[sp_databasebackup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_databasebackup]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[sp_get_sysdatetime]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_get_sysdatetime]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[checkdept]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[checkdept]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[dept]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[dept]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[fundsource]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[fundsource]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[industry]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[industry]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[payout]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[payout]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[pbcatcol]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[pbcatcol]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[pbcatedt]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[pbcatedt]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[pbcatfmt]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[pbcatfmt]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[pbcattbl]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[pbcattbl]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[pbcatvld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[pbcatvld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[project]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[project]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[project_fundsource]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[project_fundsource]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[project_plan]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[project_plan]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[unit]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[unit]
GO

CREATE TABLE [dbo].[checkdept] (
[checkdeptcode] [char] (2) NOT NULL ,
[checkdeptname] [char] (30) NULL
)
GO

CREATE TABLE [dbo].[dept] (
[deptcode] [char] (2) NOT NULL ,
[deptname] [varchar] (30) NULL
)
GO

CREATE TABLE [dbo].[fundsource] (
[fundsourcecode] [char] (2) NOT NULL ,
[fundsourcename] [char] (30) NULL
)
GO

CREATE TABLE [dbo].[industry] (
[industrycode] [char] (2) NOT NULL ,
[industryname] [char] (30) NULL
)
GO

CREATE TABLE [dbo].[payout] (
[plancode] [char] (8) NOT NULL ,
[payoutcode] [char] (4) NOT NULL ,
[payoutdate] [datetime] NULL ,
[payoutmoney] [numeric](12, 2) NULL ,
[fundsourcecode] [char] (2) NULL ,
[OperName] [char] (8) NULL
)
GO

CREATE TABLE [dbo].[pbcatcol] (
[pbc_tnam] [char] (129) NOT NULL ,
[pbc_tid] [int] NULL ,
[pbc_ownr] [char] (129) NOT NULL ,
[pbc_cnam] [char] (129) NOT NULL ,
[pbc_cid] [smallint] NULL ,
[pbc_labl] [varchar] (254) NULL ,
[pbc_lpos] [smallint] NULL ,
[pbc_hdr] [varchar] (254) NULL ,
[pbc_hpos] [smallint] NULL ,
[pbc_jtfy] [smallint] NULL ,
[pbc_mask] [varchar] (31) NULL ,
[pbc_case] [smallint] NULL ,
[pbc_hght] [smallint] NULL ,
[pbc_wdth] [smallint] NULL ,
[pbc_ptrn] [varchar] (31) NULL ,
[pbc_bmap] [char] (1) NULL ,
[pbc_init] [varchar] (254) NULL ,
[pbc_cmnt] [varchar] (254) NULL ,
[pbc_edit] [varchar] (31) NULL ,
[pbc_tag] [varchar] (254) NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[pbcatedt] (
[pbe_name] [varchar] (30) NOT NULL ,
[pbe_edit] [varchar] (254) NULL ,
[pbe_type] [smallint] NULL ,
[pbe_cntr] [int] NULL ,
[pbe_seqn] [smallint] NOT NULL ,
[pbe_flag] [int] NULL ,
[pbe_work] [char] (32) NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[pbcatfmt] (
[pbf_name] [varchar] (30) NOT NULL ,
[pbf_frmt] [varchar] (254) NULL ,
[pbf_type] [smallint] NULL ,
[pbf_cntr] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[pbcattbl] (
[pbt_tnam] [char] (129) NOT NULL ,
[pbt_tid] [int] NULL ,
[pbt_ownr] [char] (129) NOT NULL ,
[pbd_fhgt] [smallint] NULL ,
[pbd_fwgt] [smallint] NULL ,
[pbd_fitl] [char] (1) NULL ,
[pbd_funl] [char] (1) NULL ,
[pbd_fchr] [smallint] NULL ,
[pbd_fptc] [smallint] NULL ,
[pbd_ffce] [char] (18) NULL ,
[pbh_fhgt] [smallint] NULL ,
[pbh_fwgt] [smallint] NULL ,
[pbh_fitl] [char] (1) NULL ,
[pbh_funl] [char] (1) NULL ,
[pbh_fchr] [smallint] NULL ,
[pbh_fptc] [smallint] NULL ,
[pbh_ffce] [char] (18) NULL ,
[pbl_fhgt] [smallint] NULL ,
[pbl_fwgt] [smallint] NULL ,
[pbl_fitl] [char] (1) NULL ,
[pbl_funl] [char] (1) NULL ,
[pbl_fchr] [smallint] NULL ,
[pbl_fptc] [smallint] NULL ,
[pbl_ffce] [char] (18) NULL ,
[pbt_cmnt] [varchar] (254) NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[pbcatvld] (
[pbv_name] [varchar] (30) NOT NULL ,
[pbv_vald] [varchar] (254) NULL ,
[pbv_type] [smallint] NULL ,
[pbv_cntr] [int] NULL ,
[pbv_msg] [varchar] (254) NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[project] (
[projectcode] [char] (12) NOT NULL ,
[projectname] [varchar] (30) NULL ,
[enrolldate] [datetime] NULL ,
[deptcode] [char] (2) NULL ,
[industrycode] [char] (2) NULL ,
[scale] [numeric](12, 2) NULL ,
[unitcode] [char] (2) NULL ,
[budgt] [numeric](12, 2) NULL ,
[checkdeptcode] [char] (2) NULL ,
[checkfilecode] [char] (20) NULL ,
[begindate] [datetime] NULL ,
[enddate] [datetime] NULL ,
[buildtime] [numeric](18, 0) NULL ,
[fundsource] [varchar] (60) NULL ,
[OperName] [char] (8) NULL ,
[CheckFlag] [char] (1) NULL
)
GO

CREATE TABLE [dbo].[project_fundsource] (
[ProjectCode] [char] (12) NOT NULL ,
[FundSourceCode] [char] (2) NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[project_plan] (
[projectcode] [char] (12) NOT NULL ,
[plancode] [char] (8) NOT NULL ,
[plandate] [datetime] NULL ,
[filecode] [varchar] (50) NULL ,
[planmoney] [numeric](12, 2) NULL ,
[planbalance] [numeric](12, 2) NULL ,
[OperName] [char] (8) NULL ,
[CheckFlag] [char] (1) NULL
)
GO

CREATE TABLE [dbo].[unit] (
[unitcode] [char] (2) NOT NULL ,
[UnitName] [varchar] (20) NULL
) ON [PRIMARY]
GO

SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO

[am2000]

这是部分脚本...........

[tiantianpb]

利用ms sql sever 7.0 enterprise manager 生成sql文件（注意要将options->file format 选为ms-dos text(oem),默认格式是internation text(unicode),此格式不能被pb 的 fileread函数正确读出。）

[am2000]

我听了..

[am2000]

如果我的脚本内容为：
create table dept (
deptcode char(2) not null,
deptname varchar(30) null
)
执行是成功的.

[am2000]

没分了。甜姐..
am2000，欢迎您，您的专家分：4257、可用分：0、参与分：11506

[am2000]

zqllyh(找感觉)：给个sql文件的例子吧。

[am2000]

那个[]怎么去掉...

[zqllyh]

在写字板中可以替换掉[]，我手上没有70没办法知道是不是70的有[]。下面的是我65下的一个导出的文件。
/* Microsoft SQL Server - Scripting */
/* Server: 10.0.1.4 */
/* Database: bzcb */
/* Creation Date 02-1-17 8:46:36 */

/****** Object: Table QL.ac_yfqkd Script Date: 02-1-17 8:46:37 ******/
if exists (select * from sysobjects where id = object_id('QL.ac_yfqkd') and sysstat & 0xf = 3)
drop table QL.ac_yfqkd
GO

/****** Object: Table QL.ac_yfqkd Script Date: 02-1-17 8:46:37 ******/
CREATE TABLE QL.ac_yfqkd (
qkddh char (10) NULL ,
qkditemss int NULL ,
qkddepa char (6) NULL ,
qkdrq datetime NULL ,
qkdzy char (100) NULL ,
qkdfj float NULL ,
qkdinvno char (50) NULL ,
qkdje float NULL ,
qkdlcdh char (12) NULL ,
qkdpodh char (10) NULL ,
qkdprdh char (12) NULL ,
qkdyfje float NULL ,
checkyn char (1) NULL ,
accheck char (1) NULL ,
accheckman char (10) NULL ,
accheckdate datetime NULL ,
lastuser char (10) NULL ,
lastdate datetime NULL ,
cur char (4) NULL
)
GO

[fallstone]

加了[]在SQL里可以执行的吧。PB里不知道。

[tiantianpb]

也可以的

[ferbruary]

我在PB65+SQL 7下，把你帖的东西执行了，建表可以的
string ls_sql
ls_sql="CREATE TABLE [dbo].[checkdept] ( &
[checkdeptcode] [char] (2) NOT NULL ,&
[checkdeptname] [char] (30) NULL);&
CREATE TABLE [dbo].[dept] (&
[deptcode] [char] (2) NOT NULL ,&
[deptname] [varchar] (30) NULL);&
CREATE TABLE [dbo].[fundsource] (&
[fundsourcecode] [char] (2) NOT NULL ,&
[fundsourcename] [char] (30) NULL);&
CREATE TABLE [dbo].[industry] (&
[industrycode] [char] (2) NOT NULL ,&
[industryname] [char] (30) NULL);&
CREATE TABLE [dbo].[payout] (&
[plancode] [char] (8) NOT NULL ,&
[payoutcode] [char] (4) NOT NULL ,&
[payoutdate] [datetime] NULL ,&
[payoutmoney] [numeric](12, 2) NULL ,&
[fundsourcecode] [char] (2) NULL ,&
[OperName] [char] (8) NULL);&
CREATE TABLE [dbo].[pbcatcol] (&
[pbc_tnam] [char] (129) NOT NULL ,&
[pbc_tid] [int] NULL ,&
[pbc_ownr] [char] (129) NOT NULL ,&
[pbc_cnam] [char] (129) NOT NULL ,&
[pbc_cid] [smallint] NULL ,&
[pbc_labl] [varchar] (254) NULL ,&
[pbc_lpos] [smallint] NULL ,&
[pbc_hdr] [varchar] (254) NULL ,&
[pbc_hpos] [smallint] NULL ,&
[pbc_jtfy] [smallint] NULL ,&
[pbc_mask] [varchar] (31) NULL ,&
[pbc_case] [smallint] NULL ,&
[pbc_hght] [smallint] NULL ,&
[pbc_wdth] [smallint] NULL ,&
[pbc_ptrn] [varchar] (31) NULL ,&
[pbc_bmap] [char] (1) NULL ,&
[pbc_init] [varchar] (254) NULL ,&
[pbc_cmnt] [varchar] (254) NULL ,&
[pbc_edit] [varchar] (31) NULL ,&
[pbc_tag] [varchar] (254) NULL) ON [PRIMARY];&
CREATE TABLE [dbo].[pbcatedt] (&
[pbe_name] [varchar] (30) NOT NULL ,&
[pbe_edit] [varchar] (254) NULL ,&
[pbe_type] [smallint] NULL ,&
[pbe_cntr] [int] NULL ,&
[pbe_seqn] [smallint] NOT NULL ,&
[pbe_flag] [int] NULL , &
[pbe_work] [char] (32) NULL) ON [PRIMARY]; &
CREATE TABLE [dbo].[pbcatfmt] (&
[pbf_name] [varchar] (30) NOT NULL ,&
[pbf_frmt] [varchar] (254) NULL ,&
[pbf_type] [smallint] NULL ,&
[pbf_cntr] [int] NULL) ON [PRIMARY];&
CREATE TABLE [dbo].[pbcattbl] (&
[pbt_tnam] [char] (129) NOT NULL ,&
[pbt_tid] [int] NULL ,&
[pbt_ownr] [char] (129) NOT NULL ,&
[pbd_fhgt] [smallint] NULL ,&
[pbd_fwgt] [smallint] NULL ,&
[pbd_fitl] [char] (1) NULL ,&
[pbd_funl] [char] (1) NULL ,&
[pbd_fchr] [smallint] NULL ,&
[pbd_fptc] [smallint] NULL ,&
[pbd_ffce] [char] (18) NULL ,&
[pbh_fhgt] [smallint] NULL ,&
[pbh_fwgt] [smallint] NULL ,&
[pbh_fitl] [char] (1) NULL ,&
[pbh_funl] [char] (1) NULL ,&
[pbh_fchr] [smallint] NULL ,&
[pbh_fptc] [smallint] NULL ,&
[pbh_ffce] [char] (18) NULL ,&
[pbl_fhgt] [smallint] NULL ,&
[pbl_fwgt] [smallint] NULL ,&
[pbl_fitl] [char] (1) NULL ,&
[pbl_funl] [char] (1) NULL ,&
[pbl_fchr] [smallint] NULL ,&
[pbl_fptc] [smallint] NULL ,&
[pbl_ffce] [char] (18) NULL ,&
[pbt_cmnt] [varchar] (254) NULL) ON [PRIMARY];&
CREATE TABLE [dbo].[pbcatvld] (&
[pbv_name] [varchar] (30) NOT NULL ,&
[pbv_vald] [varchar] (254) NULL ,&
[pbv_type] [smallint] NULL ,&
[pbv_cntr] [int] NULL ,&
[pbv_msg] [varchar] (254) NULL) ON [PRIMARY];&
CREATE TABLE [dbo].[project] (&
[projectcode] [char] (12) NOT NULL ,&
[projectname] [varchar] (30) NULL ,&
[enrolldate] [datetime] NULL ,&
[deptcode] [char] (2) NULL ,&
[industrycode] [char] (2) NULL ,&
[scale] [numeric](12, 2) NULL ,&
[unitcode] [char] (2) NULL ,&
[budgt] [numeric](12, 2) NULL ,&
[checkdeptcode] [char] (2) NULL ,&
[checkfilecode] [char] (20) NULL ,&
[begindate] [datetime] NULL ,&
[enddate] [datetime] NULL ,&
[buildtime] [numeric](18, 0) NULL ,&
[fundsource] [varchar] (60) NULL ,&
[OperName] [char] (8) NULL ,&
[CheckFlag] [char] (1) NULL);&
CREATE TABLE [dbo].[project_fundsource] (&
[ProjectCode] [char] (12) NOT NULL ,&
[FundSourceCode] [char] (2) NOT NULL) ON [PRIMARY];&
CREATE TABLE [dbo].[project_plan] (&
[projectcode] [char] (12) NOT NULL ,&
[plancode] [char] (8) NOT NULL ,&
[plandate] [datetime] NULL ,&
[filecode] [varchar] (50) NULL ,&
[planmoney] [numeric](12, 2) NULL ,&
[planbalance] [numeric](12, 2) NULL ,&
[OperName] [char] (8) NULL ,&
[CheckFlag] [char] (1) NULL);&
CREATE TABLE [dbo].[unit] (&
[unitcode] [char] (2) NOT NULL ,&
[UnitName] [varchar] (20) NULL) ON [PRIMARY];"

SQLCA.AutoCommit=True
EXECUTE IMMEDIATE:ls_sql Using SQLCA;
IF SQLCA.SqlCode=0 THEN
MessageBox("系统提示","数据表建立成功！")
ELSE
MessageBox("系统提示","数据表建立不成功！")
END IF
SQLCA.AutoCommit=False

[zqllyh]

????,7。0的SQL脚本是有[]的吗？是不是你在生成脚本时点了什么选项生成的？
建议你干脆全部选项选中，用SA的权限，应该不会有问题，要么什么选项都不选，用
能原来的USE账号。如果是存储过程的话，有一个顺序问题。我一直都是这样做的，没什么问题。
关注。

[ferbruary]

/****** Object: Trigger dbo.basic_d Script Date: 01-11-13 14:27:27 ******/
/****** Object: Trigger dbo.basic_d Script Date: 1999-12-09 10:26:20 ******/
/****** Object: Trigger dbo.basic_d Script Date: 98-5-4 9:27:51 ******/
create trigger basic_d
on basic
for delete as
begin
delete attach
from attach,deleted where deleted.member_id=attach.member_id
delete schooling
from schooling,deleted where deleted.member_id=schooling.member_id
end
go

basic是主表，attach和schooling是副表，member_id是共同的