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