SQL Escape“ [英] SQL Escape ' '

问题描述

我试图在SQL 2008中运行查询：

  @query varchar（max）
 
 SET @query ='SELECT * FROM Table WHERE [Name] =''Karl'''
 
 EXEC（@query）
  pre> 
 
 
问题是由于某些原因，'Karl'之间的撇号不会被转义，即查询执行为 ... WHERE [Name] = Karl 并失败。
 
 
 
任何人都有建议？ p> 
 
 
谢谢
 
 
 
 Karl 
解决方案
 
这可以从SQL Server Management Studio在我的机器上工作：
  @query varchar（max）
 
 SET @query ='SELECT * FROM Table WHERE [Name] ='''''''Karl''''''''
 
 EXEC（@query）
  
 
I am trying to run a query in SQL 2008 by doing:
@query varchar(max)

SET @query = 'SELECT * FROM Table WHERE [Name] = ' 'Karl' ' '

EXEC(@query)
The problem is that for some reason the apostrophes around 'Karl' don't get escaped, i.e. the query executes as ...WHERE [Name] = Karl and fails.

Anyone have a suggestion?

Thanks

Karl
解决方案
This works on my machine from SQL Server Management Studio:
@query varchar(max)

SET @query = 'SELECT * FROM Table WHERE [Name] = ''''''Karl'''''''

EXEC(@query)


                        
这篇关于SQL Escape“的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！