如何在sqlserver中处理字符串文字中的双引号 [英] How to handle double quotes in string literal in sqlserver

问题描述

大家好，







我有一个包含列ID，名称和Desgnation的表。列名的一些记录是这样的



名称：

DilReddy

Pradeep' '''Reddy。



那么如何使用select语句获取数据。



选择*来自员工用（nolock）姓名= ???????



帮帮我。谢谢你提前...........

Hi all,



I have a table with columns ID,Name and Desgnation.Some of the records for column Name are something like this

Name:
Dil" Reddy
Pradeep'''' Reddy.

So how do i get data using select statement.

Select * from Employee with(nolock) where Name=???????

Help me out.Thanks in advance...........

推荐答案

尝试

Hi,

Try

Select * from Employee with(nolock) where Name='Dil" Reddy'

或

or

-- CHAR(34) = "
Select * from Employee with(nolock) where Name='Dil' + CHAR(34) + ' Reddy'

希望这有帮助。

Hope this helps.

另一个解决方案是使用 REPLACE [ ^ ]功能。

Another solution is to use REPLACE[^] function.

DECLARE @tbl TABLE (sName VARCHAR(30))

INSERT INTO @tbl(sName)
VALUES('Dil" Reddy')
INSERT INTO @tbl(sName)
VALUES('Pradeep'''' Reddy')
 
SELECT *
FROM (
	SELECT REPLACE(REPLACE(sName, '''',''),'"','') AS sName
	FROM @tbl) AS T
WHERE sName = 'Dil Reddy' OR T.sName = 'Pradeep Reddy'

结果：

Result:

Dil Reddy
Pradeep Reddy

这篇关于如何在sqlserver中处理字符串文字中的双引号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！