存储过程或视图之间的差异是什么?为什么在View中使用,在视图中使用的Benifits [英] What is Differance between Stored procedure or View ? Why used in View,Benifits of Used in View

查看:65
本文介绍了存储过程或视图之间的差异是什么?为什么在View中使用,在视图中使用的Benifits的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

存储过程或视图之间的区别是什么?为什么在视图中使用,在视图中使用的优点

推荐答案

访问此处:

http://www.c-sharpcorner.com/Blogs/751/difference-between- a-view-and-stored-procedure.aspx [ ^ ]

http://stackoverflow.com/questions/5194995/what-is-the-difference-between-a-stored-procedure-and-a -view [ ^ ]

http://www.aspdotnet-suresh.co m / 2013/08 / sql-server-difference-between-view-and-stored-procedure.html [ ^ ]
Visit Here:
http://www.c-sharpcorner.com/Blogs/751/difference-between-a-view-and-stored-procedure.aspx[^]
http://stackoverflow.com/questions/5194995/what-is-the-difference-between-a-stored-procedure-and-a-view[^]
http://www.aspdotnet-suresh.com/2013/08/sql-server-difference-between-view-and-stored-procedure.html[^]


主要区别存储过程和视图是,存储过程有插入/更新/删除/选择操作,我们可以在任何表上执行,使用视图是表格的形式,只有选择语句。



和视图的好处是,请查看URL。

a> [ ^ ]
The main difference of stored procedure and View is , Stored procedure has Insert/Update/Delete/Select operation that we can perform on any table and using view is the form of Table and has only select statement.

ANd the benefits of view is , please look at the URL.
http://www.c-sharpcorner.com/Blogs/10575/advantages-and-disadvantages-of-views-in-sql-server.aspx[^]


这篇关于存储过程或视图之间的差异是什么?为什么在View中使用,在视图中使用的Benifits的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆