Tables
Table 1-1: New Data Types in SQL:1999 11
Table 2-1: Code Requirements and Constructs, and SQL Server Permission Sets 50
Table 2-2: Contents of sys.assemblies 54
Table 2-3: Contents of sys.assembly_references 54
Table 2-4: Contents of sys.assembly_files 55
Table 3-1: SqlTypes Mappings to Other Types 82
Table 3-2: SqlTypes Conversions 84
Table 3-3: CLR Operations Supported by SqlTypes 89
Table 3-4: SqlFunction Properties 96
Table 4-1: SqlContext Static Properties 117
Table 4-2: Public Members of SqlConnection 119
Table 4-3: Public Members of SqlCommand 122
Table 4-4: How to Obtain Different Result Types 126
Table 4-5: Methods of the SqlPipe Class 136
Table 6-1: Security Policies for Windows and SQL Server 2005 Logins 237
Table 6-2: Encryption Choices for SQL Server Security Secrets 241
Table 6-3: EXECUTE AS Options 256
Table 6-4: General Behavior of SQL Server Permission Sets 271
Table 7-1: Versioning Database at READ COMMITTED Isolation 281
Table 7-2: Versioning Database at SERIALIZABLE Isolation 282
Table 7-3: Example of SNAPSHOT Isolation 285
Table 7-4: Versioning Database at SNAPSHOT Isolation, Concurrent Updates 287
Table 8-1: Error Functions 315
Table 8-2: Possible Values of XACT_STATE 317
Table 10-1: Columns in the Node Table 478
Table 12-1: SqlXml Managed Classes 635
Table 13-1: ODBC Metadata Columns for UDTs 656
Table 13-2: OLE DB Metadata Columns for UDTs 656
Table 13-3: ODBC Metadata for XML Data Type Column with an XML Schema Collection 666
Table 13-4: OLE DB Metadata for XML Data Type Column with an XML Schema Collection 667
Table 13-5: Metadata Columns Returned from ADO.NET for Large Value Types 668
Table 13-6: Notification Request Properties in ODBC 676
Table 13-7: Notification Request Properties in OLE DB and ADO 677
Table 14-1: Provider-Specific Classes and Generic Interfaces in ADO.NET 1.0/1.1 707
Table 14-2: Generic Base Classes and Generic Interfaces in ADO.NET 2.0 708
Table 14-3: DbProviderFactories Methods 711
Table 14-4: Example Connection-String Parameters in SQL Server APIs 716
Table 14-5: Parameter Styles and Parameter Markers in ADO.NET 2.0 Data Providers 718
Table 14-6: DataSourceInformation in Microsoft Providers 725
Table 14-7: Namespace Abbreviations Used in .NET Framework Tracepoints 737
Table 14-8: Call Types Used in .NET Framework Tracepoints 738
Table 14-9: SqlBulkCopy and BCP Equivalents 751
Table 14-10: SQL Server Version and Feature Availability 758
Table 15-1: ServerConnection Connection Properties 786
Table 15-2: Server Properties 789
Table 15-3: Properties of SqlSmoObject.Property 797
Table 15-4: Interpretation of Property.Value 799
Table 15-5: SqlSmoState Values 802
Table 16-1: Commands for NSControl 843
Table A-1: Target Switches 902
Table A-2: Members of System.Object 906
Table A-3: Syntax for Type Definitions in C# 908
Table A-4: Access Modifiers 909