April 2006
Intermediate to advanced
1088 pages
24h 51m
English
Content preview from A Developer’s Guide to SQL Server 2005Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Figures
Figure 1-1: SQL Server architecture, version 7 and above 4
Figure 1-2: Preventing managed code from interfering with SQL Server processing or writing over buffers 7
Figure 1-3: Complex types in otherwise-relational tables 9
Figure 1-4: Messages and dialogs 25
Figure 2-1: SQLOS services 29
Figure 2-2: Hosting the CLR 32
Figure 2-3: SQL Server 2005 unhandled exception escalation policy 37
Figure 2-4: .NET Framework marshaling choices. The default is to not allow marshaling 41
Figure 2-5: AppDomains in SQL Server databases 42
Figure 3-1: Pulley system 64
Figure 3-2: Pulley distance calculation 65
Figure 3-3: Create function 65
Figure 3-4: Building assembly 67
Figure 3-5: Using a CLR function 68
Figure 3-6: INFORMATION_SCHEMA.ROUTINES 69 ...