Could we at any point pass parameters to a view in SQL?

Might we at any point pass a parameter to a view in Microsoft SQL Server?

I was just seeing an Example on views in SQL Here and got stuck with doubt. I attempted to make a view in an accompanying manner, however, it doesn’t work:

create or replace view v_emp(eno number) as select * from emp where emp_id=&eno;

Any Suggestions on How it can work, Thanks in advance.

1 Like