动态sql中的单引号 [英] single quote in dynamic sql

问题描述

在动态sql中我对单引号和使用的+（加号）符号感到困惑。



例如

In dynamic sql..i am little confused regarding the single quote and the + (plus) symbol that is used.

for example

SET @sSQL ='INSERT INTO #tmpUserClaimApprovalList
(Reim_Token_ID,
EmpName)
SELECT
 tbl_Reim_Detail.Reim_Token_ID,
tbl_User_master.UserID+'+'''<br>'''+'+ tbl_User_master.First_Name+'' '+'''+ tbl_user_master.Last_Name+'''+''' as EmpName ,
from tbl_route_Detail
INNER JOIN tbl_Reim_Detail with (nolock) ON tbl_ReasonForReim.ReasonForReim_ID = tbl_Reim_Detail.Reason_ID
inner join tbl_Reim_Token with (nolock)on tbl_reim_token.Reim_token_id=tbl_reim_detail.Reim_token_id
inner join tbl_Route_header RH with (nolock) on RH.Route_id=tbl_reim_token.Route_id
inner join tbl_user_master with (nolock) on tbl_user_master.userid=tbl_reim_detail.userid
where tbl_Reim_Detail.Inactive= 0 '

--how这里使用单引号

--tbl_User_master.UserID +'+''''''''+'+ tbl_User_master.First_Name +'''+'''+

- 为什么三个'''单引号...请指导我

- 动态sql如何关闭以及如何使用单引号和+符号

--how the single quotes are used here
--tbl_User_master.UserID+'+'''
'''+'+ tbl_User_master.First_Name+'' '+'''+
--why three ''' single quotes...kindly guide me
--how the dynamic sql gets closed and how the single quotes and + symbol are used

推荐答案

看看这里：分隔标识符 [ ^ ]

如何在SQL LIKE的用户输入中转义特殊字符？ [ ^ ]

特殊字符 [ ^ ]

Have a look here: Delimited Identifiers[^]
How do I escape special characters in user input for a SQL LIKE?[^]
Special Characters[^]

这篇关于动态sql中的单引号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！