第 1 行: '(' 附近有语法错误。 682行

sql=sql&"("
sql=sql&"[id] ASC"
sql=sql&")WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]"
sql=sql&") ON [PRIMARY]"
conn.execute(sql) if conn.execute("SELECT count(*) FROM sysindexes WHERE id = OBJECT_ID(N'buy') AND name = N'IX_buy'")(0)<=0 then
sql="CREATE CLUSTERED INDEX IX_buy ON buy ("
sql=sql&"[ru_date] ASC"
sql=sql&")"
conn.execute(sql)
end if if conn.execute("select count(*) from sysobjects where name='buy_account'")(0)>0 then
conn.execute("DROP TABLE buy_account")
end if
sql="CREATE TABLE buy_account ("
sql=sql&"[id] [int] IDENTITY(1,1) NOT NULL,"
sql=sql&" [int] NULL,"
sql=sql&" [nvarchar](20) NULL,"
sql=sql&" [nvarchar](20) NULL,"
sql=sql&"[ru_date] [smalldatetime] NULL,"
sql=sql&"[ru_datetime] [datetime] NULL,"
sql=sql&"[login_id] [int] NULL,"
sql=sql&"[login_name] [nvarchar](50) NULL,"
sql=sql&"[person2_id] [int] NULL,"
sql=sql&"[person2_name] [nvarchar](50) NULL,"
sql=sql&"[zhichu_id] [int] NULL,"
sql=sql&"[zhichu_name] [nvarchar](50) NULL,"
sql=sql&"[zhichu_money] [decimal](18, 6) NULL,"
sql=sql&"[zhichu_money_fu] [decimal](18, 6) NULL,"
sql=sql&"[memo2] [nvarchar](200) NULL,"
sql=sql&"[isok] NULL,"
sql=sql&"[chong] NULL,"
sql=sql&"[contacts_id] [int] NULL,"
sql=sql&"[contacts_name] [nvarchar](50) NULL,"
sql=sql&"CONSTRAINT [PK_buy_account] PRIMARY KEY NONCLUSTERED"
sql=sql&"("
sql=sql&"[id] ASC"
sql=sql&")WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]"
sql=sql&") ON [PRIMARY]"
conn.execute(sql) if conn.execute("SELECT count(*) FROM sysindexes WHERE id = OBJECT_ID(N'buy_account') AND name = N'IX_buy_account'")(0)<=0 then
sql="CREATE CLUSTERED INDEX IX_buy_account ON buy_account ("
sql=sql&"[ru_date] ASC"
sql=sql&")"
conn.execute(sql)