在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
