SQL中in的参数怎么写

delete from table where FromPT=‘a’ and id in (1,2,3,4)



 string sql = "exec('DELETE FROM [Nop_Customer_CustomerRole_Mapping] WHERE FromPT=@FromPT and CustomerID in ('+@CustomerIDs+')')";

            SqlParameter[] paras = { new SqlParameter("@FromPT",FromPT)

                                                        ,new SqlParameter("@CustomerIDs", CustomerIDs)};

请问下 这样为什么老是说要给@FromPT赋值啊
FromPT跟CustomerIDs都有值

------解决方案--------------------
@fromPT这个参数呢?
------解决方案--------------------

 string sql = "exec('DELETE FROM [Nop_Customer_CustomerRole_Mapping] WHERE FromPT='+@FromPT+ ' and CustomerID in ('+@CustomerIDs+')')";

            SqlParameter[] paras = { new SqlParameter("@FromPT",FromPT)

                                                        ,new SqlParameter("@CustomerIDs", CustomerIDs)};

------解决方案--------------------
string sql = "DELETE FROM [Nop_Customer_CustomerRole_Mapping] WHERE FromPT=@FromPT and CustomerID in ('+@CustomerIDs+') ";
  
*****************************************************************************
签名档： http://feiyun0112.cnblogs.com/
------解决方案--------------------
'DELETE FROM [Nop_Customer_CustomerRole_Mapping] WHERE FromPT='+ @FromPT +'

你这里传进去的参数是要给exec的而不是给DELETE