用sql存儲過程實現前台標題變色

源程序:

　　ALTER   proc GetDataByNumCategory
(
@Carcategory nvarchar()
)
as
declare @sql nvarchar()
declare @Num nvarchar()
set @Num=(select top Keyword from TaoCarActive)
declare @Green  nvarchar()
declare @Green  nvarchar()
set @Green=<span style="color:Green;">
set @Green=</span>

　　declare @Red  nvarchar()
set @Red=<span style="color:Red;">
declare @Red  nvarchar()
set @Red=</span>

　　
exec(select top +@Num+ 
      ID
      case when Hits= then +@Green++CarCard++@Green+ 
      else +@Red++CarCard++@Red+ end  as CarCard   
from 
TaoCarActive where Carcategory=+@Carcategory+ order by ID)

From:http://tw.wingwit.com/Article/program/MySQL/201311/29561.html