存储过程中的单引号的问题！

[ingernew]

set @cSQL='Select * FROM BCParts where Store in ('''+@Store+''')'
EXEC (@cSQL)

为什么发生了第 2 行: ',' 附近有语法错误。
我用的值是@Store="FPP','FPG"
是不单引号用的不对，我该怎样解决谢谢！

[CrazyFor]

TRY:

set @store='fpp'',''fpg'
set @cSQL='Select * FROM BCParts where Store in ('''+@Store+''')'
EXEC (@cSQL)

[ingernew]

发生了
第 2 行: '' 附近有语法错误。

[lansquenet]

把双引号改成单引号
单引号改成两个双引号
TRY:

set @store='fpp'',''fpg'
set @cSQL='Select * FROM BCParts where Store in ('''+@Store+''')'
EXEC (@cSQL)

[lansquenet]

把双引号改成单引号
单引号改成两个单引号
TRY:

set @store='fpp'',''fpg'
set @cSQL='Select * FROM BCParts where Store in ('''+@Store+''')'
EXEC (@cSQL)

[ingernew]

不行，试了还是不行

[愉快的登山者]

TRY:

set @store='''fpp'',''fpg'''
set @cSQL='Select * FROM BCParts where Store in ('+@Store+')'
EXEC (@cSQL)

[zjcxc]

将你的全部语句贴出来.并注明你用的工具.

[ingernew]

这是C#：调用sp_FactoryRun_GetEngineer1存储过程！
public DataSet GetEngineer1byPage(string store)
{
SqlParameter[] parameters={
new SqlParameter("@Store",SqlDbType.NVarChar,550)
};

parameters[0].Value="FPP','FPG";


return RunProcedure("sp_FactoryRun_GetEngineer1",parameters,page1,page2,"Engineer1byPage");
}


这是存储过程：

CREATE PROCEDURE sp_FactoryRun_GetEngineer1
@Store nvarchar(550)
AS
declare @cSQL nvarchar(900)


set @cSQL='SELECT * FROM BCParts where Store in ('''+@Store+''')'


exec(@cSQL)

[zjcxc]

应该没问题啊.
试试在查询分析器中用下面的语句调用是否正确?

exec sp_FactoryRun_GetEngineer1 'fpp'',''fpg'

[ingernew]

试了，但通过C#传值就不行了：（

[ingernew]

通过了，是我不小心：）