sql 提示错误

[LUOLZD001]

执行如下SQL时,提示"."附近错误, 请问错在哪? 谢谢

sql = "ALTERTABLE [dbo].[ZCPCKZE] WITH NOCHECK ADD"
' sql = sql & "CONSTRAINT [PK_ZCPCKZE] PRIMARY KEY NONCLUSTERED"
' sql = sql & "("
' sql = sql & "[djh]"
' sql = sql & ") ON [PRIMARY]"
'ncnn.Execute (sql)

[Tiger_Zhao]

ALTER TABLE <- 中间要有空格。
而且ADD 和 CONSTRANT 之间也缺少空格。
执行前先 Debug.Print sql，检查语句是否正确。

[_l_]

SQL = "alter table s_tab_bmdw add ZCKJ char(20)"
cn.Execute SQL
SQL = "update s_tab_bmdw set ZCKJ=''"
cn.Execute SQL

[LUOLZD001]

不好意思,我写错了,重发! 运行时提示"."附近有错
sql = "ALTERTABLE [dbo].[ZCPKCC] WITH NOCHECK ADD"
sql = sql & "CONSTRAINT [PK_ZCPKCC] PRIMARY KEY CLUSTERED"
sql = sql & "("
sql = sql & "[cpdm]"
sql = sql & ") ON [PRIMARY]"
ncnn.Execute (sql)

[LUOLZD001]

不好意思,我发错了,重发!提示"."附近有错
sql = "ALTERTABLE [dbo].[ZCPKCC] WITH NOCHECK ADD"
sql = sql & "CONSTRAINT [PK_ZCPKCC] PRIMARY KEY CLUSTERED"
sql = sql & "("
sql = sql & "[cpdm]"
sql = sql & ") ON [PRIMARY]"
ncnn.Execute (sql)