xslt的简单使用[xml-->html] _XSL教程

IF @Filter IS NOT NULL AND @Filter != ''

BEGIN

SET @strFilter = ' WHERE ' + @Filter + ' '

SET @strSimpleFilter = ' AND ' + @Filter + ' '

END

ELSE

BEGIN

SET @strSimpleFilter = ''

SET @strFilter = ''

END

IF @Group IS NOT NULL AND @Group != ''

SET @strGroup = ' GROUP BY ' + @Group + ' '

ELSE

SET @strGroup = ''

/*执行查询语句*/

EXEC(

'

DECLARE @SortColumn ' + @type + '

SET ROWCOUNT ' + @strStartRow + '

SELECT @SortColumn=' + @strSortColumn + ' FROM ' + @Tables + @strFilter + ' ' +

@strGroup + ' ORDER BY ' + @Sort + '

SET ROWCOUNT ' + @strPageSize + '

SELECT ' + @Fields + ' FROM ' + @Tables + ' WHERE ' + @strSortColumn + @operator

+ ' @SortColumn ' + @strSimpleFilter + ' ' + @strGroup + ' ORDER BY ' + @Sort + '

'

)

GO

<!--<![CDATA[]]>-->

</Content>

<Remarks>

<Remark PostUserName="guest" PostDateTime="2006-04-10 15:26:22">

<PostUserNickName>

访客

</PostUserNickName>

<Content>

OK!

</Content>

</Remark>

<Remark PostUserName="test" PostDateTime="2006-04-10 09:18:35">

<PostUserNickName>

游客

</PostUserNickName>

<Content>

good

</Content>

</Remark>

<Remark PostUserName="dream" PostDateTime="2006-04-10 08:45:35">