Hello Dear
I am tring to pass the parameter to the View.It is giving me the syntax error
the code for your ref is :
alter VIEW temp_v_area
@area as varchar(15)
AS
SELECT *
FROM AREA
WHERE (AREANAME = @area)
please revert to me with possible solutions
I dougt whetherview accepts parameter?
Thanks in advance
PPCC
