本文介绍了在sql server中执行一个sql字符串的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我的代码如下，不知何故在@Name
My code is as below, somehow there is always an error near @Name
DECLARE @Name nvarchar(MAX) = '(mm.dll, ben and jerry.exe)'
DECLARE @sql nvarchar(MAX)= 'SELECT OrderName,
customer.version,
count(DISTINCT company.CID) as Counts
FROM [CompanyData] company
INNER JOIN [vendor] mav on company.CID = mav.CID
LEFT OUTER JOIN [Customer] customer on company.VendorId = customer.VendorId AND company.DId = customer.DId
WHERE OrderName in' + @Name+ '
GROUP BY
customer.version, OrderName'
EXEC sp_executesql @sql
推荐答案
在你的 @Name 声明中加入单引号，并删除其中的哈希(#):
Put a single quote in your declaration of @Name and just remove the hashes(#) in it:
DECLARE @Name nvarchar(MAX)='(''mm.dll'', ''ben and jerry.exe'')'
DECLARE @sql nvarchar(MAX)=
'SELECT
OrderName,
customer.version,
count(DISTINCT company.CID) as Counts
FROM [CompanyData] company
INNER JOIN [vendor] mav on company.CID = mav.CID
LEFT OUTER JOIN [Customer] customer on company.VendorId = customer.VendorId
AND company.DId = customer.DId
WHERE OrderName in ' + @Name+ '
GROUP BY customer.version, OrderName'
EXEC sp_executesql @sql
这篇关于在sql server中执行一个sql字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！
本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除！