如何用存储过程新建视图

[ltolll]

我是这样写的:

CREATE procedure createCustomerView
as begin

create view vw_ChangeMemberID
as
select ChangeMemberID.*,CustomerInfo.[Name]
from ChangeMemberID,CustomerInfo
where ChangeMemberID.CusID = CustomerInfo.[ID]

END
可是却报错,"错误156:在关键字'view'附近有语法错误."
不知为何.

[splory]

--try

CREATE procedure createCustomerView
as begin

exec('create view vw_ChangeMemberID
as
select ChangeMemberID.*,CustomerInfo.[Name]
from ChangeMemberID,CustomerInfo
where ChangeMemberID.CusID = CustomerInfo.[ID]')

END

[ww3347]

CREATE procedure createCustomerView
as
begin

exec ('create view vw_ChangeMemberID
as
select ChangeMemberID.*,CustomerInfo.[Name]
from ChangeMemberID,CustomerInfo
where ChangeMemberID.CusID = CustomerInfo.[ID]')

END

[xiaoku]

CREATE procedure createCustomerView
as begin

create view vw_ChangeMemberID
as
select ChangeMemberID.*,CustomerInfo.[Name]
from ChangeMemberID,CustomerInfo
where ChangeMemberID.CusID = CustomerInfo.[ID]

END


存储过程里面不能直接运用create view 语句..
最好还是先作个限制:
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'reminder' AND type = 'TR')
DROP TRIGGER reminder
GO

[jilate]

不明白，为什么试图要在存储过程中创建
你直接在sql里面创建不可以吗？

如果在sp里面使用，大可以使用临时表啊

[ltolll]

http://community.csdn.net/Expert/topic/5035/5035776.xml?temp=.3159143

[ltolll]

TO：jilate()
因为我的程序要新建数据库（包括里面的表、视图），我是通过程序调用存储过程来实现的，这些存储过程中保存新建表和视图的语句。
上面那个地址中是建视图时产生的问题。