在SQLServer 中update更新int字段不能加单引号,而Access中update可加单引号或不加。
例:
SQLServer :UPDATE [scan].[dbo].[cardinfo] SET [select_mark] = 1 WHERE [select_mark] = 0
Acces:UPDATE [cardinfo] SET [select_mark] = 1 WHERE [select_mark] = 0 或
UPDATE [cardinfo] SET [select_mark] ='1' WHERE [select_mark] = 0
UPDATE [cardinfo] SET [select_mark] =“1” WHERE [select_mark] = 0