SQL的in的参数化查询 

SqlCommand cmd=con.CreateCommand();
cmd.CommandText="exec('select * from novel where novelid in ('+@s+')')";
cmd.Parameters.Add("@s","'13030,12581'");

 

posted @ 2013-09-29 09:52  DCLancer  阅读(836)  评论(0)  编辑  收藏  举报
(function() { var c = document.createElement('script'); c.type = 'text/javascript'; c.async = true; c.src = ('https:' == document.location.protocol ? 'https://' : 'http://') + 'www.clicki.cn/boot/48212'; var h = document.getElementsByTagName('script')[0]; h.parentNode.insertBefore(c, h); })();