关于ADOQuery和数据库
devie 2002-10-08 03:09:41 我在程序中用ADOQuery执行SQL语句生成表
SQL为
if exists (select * from sysobjects where id = object_id(N'[dbo].[sdABC]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[sdABC]
GO
create table sdABC (
ABCCode varchar(1) not null,
ABCWorthRate smallint not null,
ABCKindRate smallint not null,
CONSTRAINT PK_sdABC PRIMARY KEY NONCLUSTERED (
ABCCode
)
)
但是总是提示“GO”附近有语法错误。
删除
if exists (select * from sysobjects where id = object_id(N'[dbo].[sdABC]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[sdABC]
GO
后可以执行
请问什么原因?