关于存储过程与视图

Question

create proc p_test
as
exec('
create view v_test
as
select 1
')

Answer 1

alter proc p_1
as
exec('create view v_1 as select * from tb ')
go

Answer 2

declare @name varchar(20)
set @name='v_test'
go
create proc p_test
as
exec('create view 视图名 as select * from stu')
go
execute p_test
在上面@name中存放的是视图名，怎么样才能把这个值放到视图创建的视图名中去呢

Answer 3

create proc p_test
(@name varchar(20))
as
set @name='v_test'
exec('create view '+@name+' as select * from stu')
go