摘要: ALTER PROC [dbo].[GetPagedDataForNotity]( @StartRowIndex INT, @MaximumRows INT, @Order VARCHAR(50), @WHERE NVARCHAR(300))AS DECLARE @SQL NVARCHAR(MAX) SET @SQL='WITH OrdersDatas AS(select id,ROW_NUMBER() over (order by '+@Order+') as rownumber from T_Notity '+@WHERE+' ) select T_ 阅读全文
posted @ 2014-01-06 10:14 kedarui 阅读(114) 评论(0) 推荐(0) 编辑