sql´æ´¢¹ý³Ì¶àÌõ¼þ²éѯ

SQL code

create PROCEDURE tdggindex
(@quyu nvarchar(50),
@fanwei nvarchar(50),
@begintime datetime,
@endtime datetime,
@startIndex INT,
@endindex INT
)
AS

declare @sql nvarchar(2000)
set @sql='select * from tdgg'
if(@quyu!='')
set @sql=@sql+' and quyu='+@quyu
if(@fanwei!='')
set @sql=@sql+' and fanwei='+@fanwei
if(@begintime!='' and @endtime!='')
set @sql=@sql+' and begintime>'+@begintime+' and endtime <'+@endtime


begin
with a as (select row_number() over(order by tingdianid desc) as row, * from (exec @sql))
select * from a WHERE Row between @startIndex and @endIndex
end
GO




ÏûÏ¢ 156£¬¼¶±ð 15£¬×´Ì¬ 1£¬¹ý³Ì tdggindex£¬µÚ 27 ÐÐ
¹Ø¼ü×Ö 'exec' ¸½½üÓÐÓï·¨´íÎó¡£

ÇëÎÊÓ¦¸ÃÈçºÎ½â¾öÕâ¸öÎÊÌ⣿лл£¡

---

@sql  ÀïÃæµÄwhere¹Ø¼ü×ÖÄØ£¿

---

select row_number() over(order by tingdianid desc) as row, * from (exec @sql)
û¼û¹ýÕâÑùµÄÓï·¨

---

declare @sql nvarchar(2000)
set @sql='select * from tdgg¡¡where 1=1'
if(@quyu!='')
set @sql=@sql+' and quyu='+@quyu
if(@fanwei!='')
set @sql=@sql+' and fanwei='+@fanwei
if(@begintime!='' and @endtime!='')