我正在尝试将一些文本数据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.
这篇关于如何在 SQL Server 中转义单引号?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!