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!='')