如何在 SQL Server 中转义单引号?

2021-12-01 00:00:00 sql delimiter tsql sql-server single-quotes

我正在尝试将一些文本数据insert 插入到 SQL Server 9 的表中.

I am trying to insert some text data into a table in SQL Server 9.

文本包含单引号'.

我该如何逃避?

我尝试使用两个单引号，但它给我带来了一些错误.

I tried using two single quotes, but it threw me some errors.

例如.insert into my_table values(' my name''s tim.');

推荐答案

单引号通过加倍转义，正如您在示例中向我们展示的那样.以下 SQL 说明了此功能.我在 SQL Server 2008 上测试过:

Single quotes are escaped by doubling them up, just as you've shown us in your example. The following SQL illustrates this functionality. I tested it on SQL Server 2008:

DECLARE @my_table TABLE (
    [value] VARCHAR(200)
)

INSERT INTO @my_table VALUES ('hi, my name''s tim.')

SELECT * FROM @my_table

结果

value
==================
hi, my name's tim.

相关文章