如何调用参数化视图

调用上述定义中的pv1视图的示例如下。

@a := select * from src where value >0;
--call view with table variable an scalar
@b := select * from pv1(@a,'20170101');
@another_day := '20170102';
--call view with table name and scalar variable
@c := select * from pv1(src2, @another_day);
@d := select * from @c union all select * from @b;
with 
t as(select * from src3)
select * from @c 
union all 
select * from @d 
union all 
select * from pv1(t,@another_day);