switch默认值问题

[xuanhuangkeji]

switch条件中没有设置default 且没有命中比较值时，依旧会有where关键词出现，导致sql语句生成不正确

exec sp_executesql N'Select TT.* From
(Select ROW_NUMBER() Over(Order By T.Id Desc) Row_Index,T.* From MiniCustomer T With(NoLock)
) TT
Where TT.Row_Index Between ((@PageIndex-1)@PageSize+1) And (@pageindex@PageSize);',N'@pageindex int,@PageSize int',@pageindex=1,@PageSize=16