SQL中in的参数怎么写

Question

本帖最后由 chai1338 于 2014-03-14 10:02:28 编辑

Answer 1

 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)};

Answer 2

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

Answer 3

Quote: 引用 3 楼 feiyun0112 的回复:

string sql = "DELETE FROM [Nop_Customer_CustomerRole_Mapping] WHERE FromPT=@FromPT and CustomerID in ('+@CustomerIDs+') ";
  
*****************************************************************************
in内传参数 不需要用exec吗？

Answer 4

'DELETE FROM [Nop_Customer_CustomerRole_Mapping] WHERE FromPT='+ @FromPT +'你这里传进去的参数是要给exec的而不是给DELETE