网站建设手机app,织梦网站 伪静态,注册公司需要钱吗,黑马教育培训官网http://www2.gliet.edu.cn/club2/bbs/list_new_today.asp用于列出今日最新贴的。有个想不明的问题是为什么DeclareSqlText Varchar(1000)声明为1000个字符大了#xff0c;但超过255字符之后exec(SqlText)就会出错。自动把后面的cut掉了#xff1f;ALTERPROCEDUREbbsListNewTo…http://www2.gliet.edu.cn/club2/bbs/list_new_today.asp用于列出今日最新贴的。有个想不明的问题是为什么Declare SqlText Varchar(1000)声明为1000个字符大了但超过255字符之后exec(SqlText)就会出错。自动把后面的cut掉了 ALTER PROCEDURE bbsListNewTodaycurPage int 0, --当前页PageSize int 30--每页记录数--ForumID varchar(4) ,--每页记录数--condition varchar(200),--tolRecord int output ado.command对象返回记录集时就不能用输出参数了 ASbeginset nocount ondeclare StartRecord int declare EndRecord int Declare SqlText Varchar(1000)Declare selCol Varchar(1000)Declare fcondition varchar(1000)Declare sPageSize varchar(10)Declare tolRecord intif curPage0begin set curPage curPage-1endset StartRecord curPage * PageSizeset EndRecord (curPage 1 ) * PageSizeset fcondition where boards.[user]bbs.owner set sPageSize CAST( PageSize AS varchar(30)) --select len(condition)--返回总贴数 set tolRecord(select sum(totalCount) from boards)--set SqlText select top CAST( pageSize AS varchar(30)) * from bbs order by id descset selCol N bbs.[id] bbsid,TopID,[Owner] boardID,Layer,Click,[Time] postTime,Topic,bbs.[Name] poster,TxtLong,Face,IsBest,IsTop,subject boardNameif curPage0begin set SqlText select top sPageSize CAST( tolRecord AS varchar(10)) as tolRecord, selCol from bbs,boards fcondition order by bbsid descendelsebegin set SqlText select CAST( tolRecord AS varchar(10)) as tolRecord,* from( select top CAST( sPageSize AS varchar(10)) * from( select top CAST( EndRecord AS varchar(10))selCol from bbs,boards fcondition order by bbsid desc ) a order by bbsid ) b order by bbsid descendexec(SqlText)set nocount off endGO转载于:https://www.cnblogs.com/wuchang/archive/2004/08/20/35192.html
