SQL Server Passing parameters in VIEW
The short answer is that a VIEW is just a static representation of tabular data – and cannot accept a parameter. However, one can accomplish the same thing by doing passing the parameter in the QUERY after creating the view…
VIEW
create view v_emp as select * from emp ;
Query
select * from v_emp where emp_id=&eno;
Leave a Reply