Microsoft SQL Server 2005 New Features [Electronic resources]

Michael Otey

نسخه متنی -صفحه : 80/ 76
نمايش فراداده

Index

V

-v switch, using with Sqlcmd, 38–39

Value() method, using with XML data types, 149

Value property

accessing for UDTs, 84

using with UDTs, 84

varbinary(max) data type, support for, 7–8

varchar(max) data type, T-SQL support for, 95

variables

declaring for UDAGGs, 87

Integration Services support for, 194–196

MFType UDT as, 84

using with Sqlcmd, 39

VB.NET

defining GetSalespersonCount method in, 74

using .NET data providers with, 72

Version* system variables, purpose in Integration Services, 196

VIEW DEFINITION permission

and catalog security, 21

description of, 20

views versus CTEs, 90

Visual Studio 2005

adding UDFs with, 76

adding UDTs with, 78–79

creating CLR stored procedures in, 72–73

creating UDAGGs in, 86

creating UDTs in, 80–81

generating UserDefinedFunctions class in, 77

VLDBs (very large databases), and data partitioning, 10