Go homepage(回首页)
Upload pictures (上传图片)
Write articles (发文字帖)

The author:(作者)归海一刀
published in(发表于) 2014/2/3 6:46:54
用sql存储过程实现前台标题变色_[SQL Server教程]

ALTER proc GetDataByNumCategory
(
@Carcategory nvarchar(50)
)
as
declare @sql nvarchar(1000)
declare @Num nvarchar(20)
set @Num=(select top 1 Keyword from TaoCarActive)
declare @Green nvarchar(100)
declare @Green1 nvarchar(100)
set @Green=''
set @Green1=''

declare @Red nvarchar(100)
set @Red=''
declare @Red1 nvarchar(100)
set @Red1=''

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

赞