如何使用sql中的过程创建视图? [英] How can i create a view using procedure in sql?

问题描述

我正在按照以下步骤在视图中创建视图.

Hi i am creating the view inside the procedure as following.

GO
ALTER procedure [dbo].[ravilla]
 as
begin 
execute( 'create view  ------  as select ---------')
end

程序执行成功，但是.视图未创建.


我如何在过程内创建视图.....

Procedure is executing successfully but . view is not creating.


How can i create view inside procedure.....

推荐答案

您无法在过程内创建视图.

请参阅此链接
http://social.msdn.microsoft.com/Forums/zh-CN/sqlgetstarted/thread/af8b0c2d-8117-42e3-a701-05035644f73d [

you can''t create view inside procedure.

refer this link
http://social.msdn.microsoft.com/forums/en-US/sqlgetstarted/thread/af8b0c2d-8117-42e3-a701-05035644f73d[^]

嗨.
您可以使用sqlServer中存在的模板(如果使用SQLserver2008)

按照这种方式:

转到视图(标签)->模板资源管理器->在
顶部选择按钮sql server 模板资源管理器->选择观景台->创建视图

您还可以使用Ctrl + Alt + T

==如果有帮助，请标记==

hi.
you can use templates that exist in sqlServer(if you use SQLserver2008)

follow this way:

go to view(tab)--> Template Explorer --> choose button sql server in top of the
template explorer --> choose view forlder --> create view

you can also use Ctrl+Alt+T

==if it was helpful please mark==

这篇关于如何使用sql中的过程创建视图?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！