. , , , , , , . , .
- . .
(views) , . .
select, . Select. , (join) (union) , , , .
SQL Server 2000 : Enterprise Manager; Create View Wizard; Transact-SQL.
Enterprise Manager. . , , , , .
, , Transact-SQL, . Transact-SQL, .
Enterprise Manager , , Views. 18, ( Name), ( Owner), (type) (Create Date).
Views New View New .
, , . .
. , .. . , . . . , , . , , .
|
|
, . , , . , . . , , . , , . , . , . , . . , , . , , .
. , . .
SQL Server 2000 . , , , . , . , , . SQL Server 2000.
, SQL Server 2000, , , .. . . , . . , . , . , , , . .
|
|
, , , . , , , , .
, . sysindexes, . . statblob, image, 2 .
, . , . . . , .
, . , . . .
Transact-SQL
. , (SQL, Structured Query Language).
SQL -. , , , SQL. , (query), . . , .
1992 . (ANSI, American National Standard Institute) SQL, ANSI SQL-92. , , , . , ANSI SQL-92 .
ANSI SQL-92 , . , . , , . ANSI SQL-92 , , , .
Microsoft, , SQL, Transact-SQL. SQL Server 2000 . ANSI SQL-92, , . Transact-SQL Microsoft, .