我试图删除数据库中的一行,但由于某种原因它无法正常工作.
SELECT * FROMWHERE MAPPING_ID = '66' AND FIELD_VALUE = 'Sanità' AND PARENT_VALUE = 'ITA';
结果: 66 Sanità ITA
DELETE FROMWHERE MAPPING_ID = '66' AND FIELD_VALUE = 'Sanità' AND PARENT_VALUE = 'ITA';
结果: 0 rows deleted.
我猜它是由于à.我已经有了SET DEFINE OFF
,但仍然没有去.
有什么建议?
DELETE FROMWHERE MAPPING_ID = '66' AND FIELD_VALUE = N'Sanità' AND PARENT_VALUE = 'ITA';
试试这个N用于匹配nvarchar值(Unicode)
希望这会帮助你.