sqlserver paging,searching and sorting

Hi Satish, use below code ---------- declare @pageindex int,@PageSize int,@OrderBy varchar(max),@Searchtxt varchar(MAX) ----------------------- declare @strtdata int declare @enddata int ------------------------------paging logic--------------------------------- if (@pageIndex = 0) begin set @strtdata = 0 set @enddata = @pageSize end else begin set @strtdata = (((@pageIndex - 1) + 1) * @pageSize) + 1 set @enddata = (((@pageIndex - 1) + 1) * @pageSize) + @pageSize end ------------------------------------------------------------------------------------------ set @Searchtxt='where columnname like ''%'+Convert(varchar,@Searchtxt) +'%''' declare @qry varchar(max)='' set @qry=' select *, ROW_NUMBER() OVER (ORDER BY ColumnName desc ) rownum from Table 1 where '+@Searchtxt+' ' exec(@qry)