07-31-2023, 12:57 AM
Can we pass a parameter to a view in Microsoft SQL Server?
I tried to `create view` in the following way, but it doesn't work:
create or replace view v_emp(eno number) as select * from emp where emp_id=&eno;
I tried to `create view` in the following way, but it doesn't work:
create or replace view v_emp(eno number) as select * from emp where emp_id=&eno;