sp_executesql 问题。
exec sp_executesql N'set rowcount @num
select id,title,link_url,logo_url from [163car_adv] where board=@board order by b_index',N'@board varchar(50),@num int',N'index',3
其中board为字符串型。
为什么 board=@board 改成 board=''@board'' 反而不对呢?
exec sp_executesql N'set rowcount @num
select id,title,link_url,logo_url from [163car_adv] where board=''@board'' order by b_index',N'@board varchar(50),@num int',N'index',3