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+') ";
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)};
*****************************************************************************
签名档: http://feiyun0112.cnblogs.com/