SELECT Small_Sort,Compositor,
'Info_List_2.aspx?Sort='+CAST(Parent_Sort AS VARCHAR)+'&Small_Sort='+CAST(Compositor AS VARCHAR) AS Url
FROM Small_Sort
WHERE Parent_Sort = '1'
AND Compositor IN (2,4,5)
UNION ALL
SELECT TOP 1 (CASE small_Sort WHEN 1 THEN '公司介绍'
WHEN 3 THEN '发展规划'
WHEN 6 THEN '参股公司' END) AS small_Sort,
small_Sort AS compositor,
'Page_Info_1.aspx?News_Id='+CAST(id AS VARCHAR) AS url
FROM news
WHERE Sort=1
AND small_Sort IN (1,3,6)
'Info_List_2.aspx?Sort='+CAST(Parent_Sort AS VARCHAR)+'&Small_Sort='+CAST(Compositor AS VARCHAR) AS Url
FROM Small_Sort
WHERE Parent_Sort = '1'
AND Compositor IN (2,4,5)
UNION ALL
SELECT TOP 1 (CASE small_Sort WHEN 1 THEN '公司介绍'
WHEN 3 THEN '发展规划'
WHEN 6 THEN '参股公司' END) AS small_Sort,
small_Sort AS compositor,
'Page_Info_1.aspx?News_Id='+CAST(id AS VARCHAR) AS url
FROM news
WHERE Sort=1
AND small_Sort IN (1,3,6)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货