Trying To Create A View With Parameters.

Trying to create a view with parameters. I want to use view inside the SP. But I'm getting an error. Why?



-- 1st
-- drop table funkete
create table funkete (funketeid int, funketeFname varchar(20))
insert funkete
select 1, 'funkete' union all
select 5, 'amanda' union all
select 6, 'funkete'
go

-- 2nd
-- drop proc a
create proc a (@funketeid int)
as
select @funketeid, funketefname from funkete
go

-- 3rd
exec a @funketeid = 4
go

-- 4th
create view vw_funkete4 as
declare @funketeid int
select @funketeid, funketefname from funkete
go



=============================
http://www.sqlserverstudy.com