明明声明了，为什么会显示没有声明变量@business_codea 呢?

Question

try:
CREATE PROCEDURE XC_XMLWriter.MakePriceXML AS--Execute master..xp_cmdshell 'bcp "select * from xuncai.xc.price as PRICE for xml auto" queryout d:\XMLFILES\Params_XML.xml -c -UXC_XMLWriter  -P123456 -Sxuncaiserver'
--set @business_code='''TEXT_00000'',''TEXT_00001'',''TEXT_00002'''set @business_codea='''TEXT_00000'',''TEXT_00001'',''TEXT_00002'',''TEXT_00003'''exec master..xp_cmdshell '
declare @business_codea varchar(100) bcp set @business_codea='''TEXT_00000'',''TEXT_00001'',''TEXT_00002'',''TEXT_00003''' "select price from xc.services as bbb where service_id in (select service_id from xc.business where charindex(business_code,@business_codea)>0) for xml auto" queryout d:\bbb.xml -c -UXC_XMLWriter -P123456 -Sxuncaiserver'
GO

Answer 1

CREATE PROCEDURE XC_XMLWriter.MakePriceXML AS--Execute master..xp_cmdshell 'bcp "select * from xuncai.xc.price as PRICE for xml auto" queryout d:\XMLFILES\Params_XML.xml -c -UXC_XMLWriter  -P123456 -Sxuncaiserver'
declare @business_codea varchar(100)
--set @business_code='''TEXT_00000'',''TEXT_00001'',''TEXT_00002'''set @business_codea='''TEXT_00000'',''TEXT_00001'',''TEXT_00002'',''TEXT_00003'''exec master..xp_cmdshell 'bcp "select price from xc.services as bbb where service_id in (select service_id from xc.business where charindex(business_code,'+@business_codea+')>0) for xml auto" queryout d:\bbb.xml -c -UXC_XMLWriter -P123456 -Sxuncaiserver'
GO

Answer 2

CREATE PROCEDURE XC_XMLWriter.MakePriceXML AS--Execute master..xp_cmdshell 'bcp "select * from xuncai.xc.price as PRICE for xml auto" queryout d:\XMLFILES\Params_XML.xml -c -UXC_XMLWriter  -P123456 -Sxuncaiserver'
declare @business_codea varchar(100)
--set @business_code='''TEXT_00000'',''TEXT_00001'',''TEXT_00002'''set @business_codea='''TEXT_00000'',''TEXT_00001'',''TEXT_00002'',''TEXT_00003'''exec master..xp_cmdshell 'bcp "select price from xc.services as bbb where service_id in (select service_id from xc.business where charindex(business_code,'+@business_codea+')>0) for xml auto" queryout d:\bbb.xml -c -UXC_XMLWriter -P123456 -Sxuncaiserver'
GO

Answer 3

CREATE PROCEDURE XC_XMLWriter.MakePriceXML AS--Execute master..xp_cmdshell 'bcp "select * from xuncai.xc.price as PRICE for xml auto" queryout d:\XMLFILES\Params_XML.xml -c -UXC_XMLWriter  -P123456 -Sxuncaiserver'
declare @business_codea varchar(100)
--set @business_code='''TEXT_00000'',''TEXT_00001'',''TEXT_00002'''set @business_codea='''TEXT_00000'',''TEXT_00001'',''TEXT_00002'',''TEXT_00003'''
declare @a varchar(8000)
set @a='bcp "select price from xc.services as bbb where service_id in (select service_id from xc.business where charindex(business_code,'+@business_codea+')>0) for xml auto" queryout d:\bbb.xml -c -UXC_XMLWriter -P123456 -Sxuncaiserver'
exec master..xp_cmdshell @a
GO