关于SQLServer2005中的视图 [英] About Views in SQLServer2005

问题描述

i want to know more about how do we use views in our procedures

虽然有点复杂，但我想深入了解...
请建议并指导我在过程中创建和使用视图.

i want to know more about how do we use views in our procedures

Though it is a bit complicated one i would like to go deep with views...
Please suggest and guide me in creating and using views in my procedures.

推荐答案

视图不仅适用于过程，而且在很多情况下都可以使用视图，因为它起作用了(几乎)就像桌子一样.

作为起点，请参阅:设计和实现视图 [

Views are not just for procedures you can use a view in many situations since it acts (almost) like a table.

As a starting point, see: Designing and Implementing Views[^]

如果需要在存储过程中创建一些用于保存数据的东西，那么您可能需要研究临时表. (

If you need to create something for holding data in a stored procedure, then you may need to investigate temp tables. ( Clickey[^]).
If you just need to read data from view, they can be treated exactly like a read-only table.

这篇关于关于SQLServer2005中的视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！