SELECT
TOP 1
@NewsId=F_ArticleId ,
@NewsTitle=F_ArticleTitle ,
@NewsDate=left(convert(varchar(10),F_ArticleDate),10)
FROM T_article
ORDER BY F_ArticleDate吧, 你怎么写top 7
TOP 1
@NewsId=F_ArticleId ,
@NewsTitle=F_ArticleTitle ,
@NewsDate=left(convert(varchar(10),F_ArticleDate),10)
FROM T_article
ORDER BY F_ArticleDate吧, 你怎么写top 7
SELECT TOP 7 F_newstitle,left(convert(varchar(10),F_newsdate),10) as F_newsdate FROM T_news ORDER BY F_newsdate用这条命令的时候没问题