新手求助，十万火急！！！！！！
declare @sBClassID varchar(2),@sSearchValue varchar(100),@sSearchKey varchar(10),@sql varchar(200)
set @sBClassID= '01 '
set @sSearchValue= '%c% '
set @sSearchKey= 'Book_Name '
set @sql = 'select a.*,b.Pub_Name from T_Books a,T_Publishers b
where a.Pub_ID=b.Pub_ID and a.BClass_ID= '+ @sBClassID+ ' and '+ @sSearchKey + ' like '+ @sSearchValue +
' order by a.Book_AddDate desc '
exec (@sql)
请问怎么样可以解决
[解决办法]
declare @sBClassID varchar(2),@sSearchValue varchar(100),@sSearchKey varchar(10),@sql varchar(200)
set @sBClassID= '01 '
set @sSearchValue= '%c% '
set @sSearchKey= 'Book_Name '
set @sql = 'select a.*,b.Pub_Name from T_Books a,T_Publishers b
where a.Pub_ID=b.Pub_ID and a.BClass_ID= '+ @sBClassID+ ' and '+ @sSearchKey + ' like ' ' '+ @sSearchValue +
' ' ' order by a.Book_AddDate desc '
exec (@sql)
