A Developer’s Guide to SQL Server 2005

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 ...