如何在SQL Server中修改或转义下面的insert查询:
INSERT INTO <tblname> (title,desc)
VALUES
('Hen's Body','It's just best combination')此查询未在SQL Server中运行。我需要类似的MySQL解决方案(如使用反斜杠),因为它是
INSERT INTO <tblname> (title,desc)
VALUES('Hen\'s Body','It\'s just best combination')问候
发布于 2010-12-08 18:25:40
用双引号将它们转义:
INSERT INTO ( title, description )
VALUES ( 'Hen''s Body', 'It''s just best combination' )https://stackoverflow.com/questions/4386400
复制相似问题