您所在位置：主题：高手帮助一下，ASP语言中用SQL语句建表
robinliu
[专家分：0] 发布于 2007-11-04 11:37:00
我想在ASP中用SQL语言建表
Set oconn = Server.CreateObject("ADODB.Connection")
oconn.Open"DSN=lookbook;UID=sa;PWD=12345"
oconn.execute"CREATE TABLE [dbo].['"&Trim(ookname)&"'] ([Num] [int] NOT NULL ,[ZJNum] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,[ZJName] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,[Ltime] [datetime] NULL ) ON [PRIMARY] GO"
但是最后显示是在'GO'附近有错误
Set oconn = Server.CreateObject("ADODB.Connection")
oconn.Open"DSN=lookbook;UID=sa;PWD=12345"
oconn.execute"CREATE TABLE [dbo].['"&Trim(ookname)&"'] ([Num] [int] NOT NULL ,[ZJNum] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,[ZJName] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,[Ltime] [datetime] NULL ) ON [PRIMARY] GO"
但是最后显示是在'GO'附近有错误