执行如下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)
' sql = sql & "CONSTRAINT [PK_ZCPCKZE] PRIMARY KEY NONCLUSTERED"
' sql = sql & "("
' sql = sql & "[djh]"
' sql = sql & ") ON [PRIMARY]"
'ncnn.Execute (sql)
cn.Execute SQL
SQL = "update s_tab_bmdw set ZCKJ=''"
cn.Execute SQL
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)
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)
而且ADD 和 CONSTRANT 之间也缺少空格。
执行前先 Debug.Print sql,检查语句是否正确。