lmq451

请问大家谁知道下列中的的　 strsql="select top 10 bookid,  CommentCaption=UserName+':'+SUBSTRING(Caption,0,50) from comment ";
怎么解释？？谢谢讲解！！！

public DataView GetCommentTop10()
  {
   string strsql;
   DataSet myDs;
   strsql="select top 10 bookid,  CommentCaption=UserName+':'+SUBSTRING(Caption,0,50) from comment ";
   myDs=ExecuteSql4Ds(strsql);
   return myDs.Tables[0].DefaultView ;
  }