在sqlserver中查看概念 [英] views concept in sqlserver

问题描述

任何人都可以解释sqlserver中的观点概念

can any one explain views concept in sqlserver

推荐答案

是的， google [ ^ ]！

In SQL, a view is a virtual table based on the result-set of an SQL statement.

A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.

You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.

CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition

请参考 http://www.w3schools.com/sql/sql_view.asp [ ^ ]

请参阅以下链接。它可能有助于您了解视图。



http://www.dotnet-tricks.com/Tutorial/sqlserver/b4H8260312-Different-Types-of-SQL-Server-Views.html [ ^ ]



SQL Server 2005中的视图概述 [ ^ ]



http://www.c-sharpcorner.com/uploadfile/skumaar_mca/views-in-sql-server-2005/ [ ^ ]

Hi,

See the below link. It may be help you to get the idea of Views.

http://www.dotnet-tricks.com/Tutorial/sqlserver/b4H8260312-Different-Types-of-SQL-Server-Views.html[^]

Overview of Views in SQL Server 2005[^]

http://www.c-sharpcorner.com/uploadfile/skumaar_mca/views-in-sql-server-2005/[^]

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