V

VALUE (reserved word), 464, 466

VALUES (reserved word), 461, 464

values, returning, 369–370

VAR() function, 208, 210–211, 472

VARCHAR (reserved word), 464, 466

VARIABLE (reserved word), 466

VARP() function, 208, 211, 472

VARYING (reserved word), 461, 464

@@VERSION, 169, 469

version control, 116–117

Viera, Rob

Beginning SQL Server 2005 Programming, 1 Professional SQL Server 2000 Programming, 1, 304

Professional SQL Server 2005 Programming, 1, 304

VIEW (reserved word), 461, 464

VIEW_CATALOG view, 518

VIEW_COLUMN_USAGE views

COLUMN_NAME view, 518

TABLE_CATALOG view, 518

TABLE_NAME view, 518

TABLE_SCHEMA view, 518

VIEW_CATALOG view, 518

VIEW_NAME view, 518

VIEW_SCHEMA view, 518

VIEW_DEFINITION view, 518

VIEW_NAME view, 518

views

complexity, hiding, 364–365

creating views, 351–356

creation of, 118

federated views, 360–363

Microsoft Access, creating views in, 351–353

modifying data through views, 365–366

naming, 324

partitioned views, 357–360

rows, ordering, 356–357

securing data, 363

SQL Script, creating views in, 354–356

updating data transactions using, 267

views, 350–366

virtual tables, 350

Visual Studio, creating views in, 353–354

VIEWS

CHECK_OPTION view, 518

IS_UPDATABLE view, 518

TABLE_CATALOG view, 518

TABLE_NAME view, 518

TABLE_SCHEMA view, 518

VIEW_DEFINITION view, 518

VIEW_SCHEMA view, 518

VIEW_TABLE_USAGE views

TABLE_CATALOG view, 518

TABLE_NAME view, 518

TABLE_SCHEMA view, 518

VIEW_CATALOG view, 518

VIEW_NAME view, 518

VIEW_SCHEMA view, 518

virtual tables, 350

Visual Studio, creating views in, 353–354