UC知道如何将mssql中导出的SQL语句在ASP中运行
来源：百度知道 编辑：UC知道 时间：2024/05/24 20:59:01
我在MSSQL中创建了个数据表，导出了如下SQL语句，并在查询分析器中执行可以通过
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
CREATE TABLE dbo.Z_ktbj
(
tid int NOT NULL IDENTITY (1, 1),
times datetime NULL,
goodsid int NOT NULL,
shul int NOT NULL,
danj int NULL,
qih char(16) NULL,
jxs int NULL,
keu char(16) NULL,
lxr char(16) NULL,
tel char(16) NULL,
phone char(16) NULL,
fax char(16) NULL,
addr char(16) NULL,
opid int NULL
) ON [PRIMARY]
GO
ALTER TABLE dbo.Z_ktbj ADD CONSTRAINT
PK_Z_ktbj PRIMARY KEY CLUSTERED
(
tid
) ON [PRIMARY]
GO
COMMIT
现在我想在ASP中执行
我用以下语句可以添加成功数据
CreateTableSql = "create table [z_ktbj]([ktid] varchar(100) not null, [goodid]
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
CREATE TABLE dbo.Z_ktbj
(
tid int NOT NULL IDENTITY (1, 1),
times datetime NULL,
goodsid int NOT NULL,
shul int NOT NULL,
danj int NULL,
qih char(16) NULL,
jxs int NULL,
keu char(16) NULL,
lxr char(16) NULL,
tel char(16) NULL,
phone char(16) NULL,
fax char(16) NULL,
addr char(16) NULL,
opid int NULL
) ON [PRIMARY]
GO
ALTER TABLE dbo.Z_ktbj ADD CONSTRAINT
PK_Z_ktbj PRIMARY KEY CLUSTERED
(
tid
) ON [PRIMARY]
GO
COMMIT
现在我想在ASP中执行
我用以下语句可以添加成功数据
CreateTableSql = "create table [z_ktbj]([ktid] varchar(100) not null, [goodid]
当然是可以的，你使用的的IDENTITY (1, 1)以及PRIMARY KEY就可以，
只不过需要调整一下顺序，具体使用下面的SQL语句就可以了，
CREATE TABLE Z_ktbj ( tid Int IDENTITY primary key NOT NULL, times datetime NULL, goodsid int NOT NULL, shul int NOT NULL, danj int NULL, qih char(16) NULL, jxs int NULL, keu char(16) NULL, lxr char(16) NULL, tel char(16) NULL, phone char(16) NULL, fax char(16) NULL, addr char(16) NULL, opid int NULL )
将上面这个SQL语句赋值给执行的SQL语句变量，在程序中调用执行就可以了，
呵呵，希望能有帮助，^_^