其中一个字段为空时,取出另一个字段数据。例:NewsShortTitle不为空取出,为空标题取出NewsTitleSELECT TOP 5
NewsID,ClassID,
(select ClassName from CMS_ClassNode where ClassID=View_News.ClassID)
as ClassName,NewsTitle,NewsShortTitle,
NewsAuthor,NewsUrlFrom,NewsPic,
NewsCss,NewsDes,NewsHit,NewsTJ,
NewsCheck,NewsIsToHtml,AddTime,ModTime,ModAdminName
from View_News where ClassID IN('13') order by AddTime DESC
NewsID,ClassID,
(select ClassName from CMS_ClassNode where ClassID=View_News.ClassID)
as ClassName,NewsTitle,NewsShortTitle,
NewsAuthor,NewsUrlFrom,NewsPic,
NewsCss,NewsDes,NewsHit,NewsTJ,
NewsCheck,NewsIsToHtml,AddTime,ModTime,ModAdminName
from View_News where ClassID IN('13') order by AddTime DESC
NewsID,ClassID,
(select ClassName from CMS_ClassNode where ClassID=View_News.ClassID)
as ClassName,NewsTitle,isnull(NewsShortTitle,NewsTitle) as NewsShortTitle,
NewsAuthor,NewsUrlFrom,NewsPic,
NewsCss,NewsDes,NewsHit,NewsTJ,
NewsCheck,NewsIsToHtml,AddTime,ModTime,ModAdminName
from View_News where ClassID IN('13') order by AddTime DESC