你好老师!又遇到个问题想请教一下你,我现状用intouch往SQL中间表里上传数据,共有2个表。有一个表UPDate和insert时报错“语法错误”-1: Microsoft SQL Server Native Client 11.0: Incorrect syntax near ','.
我检查了两个表的写法是一样的,不知为何一个可以而另一个报错?
正常的表写法:
ResultCode = SQLInsert( ConnectionID, "device", "Device" );
ResultCode = SQLUpdate( ConnectionID, "device", "Device", "1=1" );
报错的表写法:
ResultCode = SQLInsert( ConnectionID, "Device_New", "device_new" );
ResultCode = SQLUpdate( ConnectionID, "Device_New", "device_new", "1=1" );
连接数据库ResultCode = SQLConnect(ConnectionID,"rovider=SQL Server Native Client 11.0;User ID=saassword=p@ssw0rd;Initial Catalog=intouch;Data Source=A881PM25;");
正常,测试表头不一致时的保持的报错不是这样的报错。请问老师这个报错是什么意思,我还要检查那些方面,请指教一下,谢谢!
|