摘要:
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_ 阅读全文