O'Reilly logo

A Developer’s Guide to SQL Server 2005 by Dan Sullivan, Bob Beauchemin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required