|
XSLT命令[xml格式转换] 1.循环 <xsl:for-each...> <xsl:for-each select="BookList/Item"> <tr> <th align="left"> <xsl:value-of select=".//title" /></th> <td><xsl:value-of select=".//categroy" /></td> <td><xsl:value-of select=".//release-date" /></td> <td><xsl:value-of select=".//author" /></td> <td><xsl:value-of select="@price" /></td> </tr> </xsl:for-each> 2.排序 <xsl:sort...> 3.条件处理 <xsl:if...>或<xsl:choose...>或<xsl:when...> 4.名称模板 <xsl:template name...<xsl:template name...>,<xsl:param...> <xsl:with-param...>,<xsl:call-template...> 5.编号方式 <xsl:number value format...> xml文档[Article.xml] <?xml version="1.0" encoding="gb2312" ?> <?xml-stylesheet type='text/xsl' href='Article.xsl'?> <Articles> <Article> <ArticleID>2897</ArticleID> <Title>[分享]千万数量级分页存储过程（带效果演示）</Title> <Author>网络</Author> <Abstract>[分享]千万数量级分页存储过程（带效果演示）</Abstract> <PostDateTime>2006-02-27 18:29:53</PostDateTime> <Dots>7</Dots> <ColumnURL>/web/Article/viewColumn.aspx?ColID=19</ColumnURL> <ColumnID>19</ColumnID> <ColumnName>SQL Server</ColumnName> <FileType>1</FileType> <FilePath>resource/sql server/2006-02-27/20060227182953.htm</FilePath> <Editor>网络</Editor> 伊图教程网[www.etoow.com] http://www.etoow.com/html/2007-08/1187530290.html <Content>
(责任编辑：admin)[分享]千万数量级分页存储过程 CREATE PROCEDURE CN5135_SP_Pagination /****************************************************************** 千万数量级分页存储过程 ******************************************************************* 参数说明: 1.Tables :表名称,视图 2.PrimaryKey :主关键字 3.Sort :排序语句，不带Order By 比如：NewsID Desc,OrderRows Asc 4.CurrentPage :当前页码 5.PageSize :分页尺寸 6.Filter :过滤语句，不带Where 7.Group :Group语句,不带Group By ***************************************************************/ ( @Tables varchar(1000), @PrimaryKey varchar(100), @Sort varchar(200) = NULL, @CurrentPage int = 1, @PageSize int = 10, @Fields varchar(1000) = '*', @Filter varchar(1000) = NULL, @Group varchar(1000) = NULL ) AS /*默认排序*/ IF @Sort IS NULL OR @Sort = '' SET @Sort = @PrimaryKey DECLARE @SortTable varchar(100) DECLARE @SortName varchar(100) DECLARE @strSortColumn varchar(200) >DECLARE @operator char(2) |