Microsoft SQL Server 2008 R2 Unleashed- P208:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 1864 CHAPTER 46 SQLCLR Developing SQL Server Objects in .NET ORDER BY assembly_id desc go name assembly_id permission_set SQLCLR 65719 UNSAFE_ACCESS 65705 UNSAFE_ACCESS 65704 UNSAFE_ACCESS 65703 UNSAFE_ACCESS 65702 UNSAFE_ACCESS Now that you have the assembly_id for your SQLCLR project yours will not be the same value as shown here you can look up its routines and classes in SELECT TOP 5 name assembly_class as class assembly_method as method FROM am JOIN a ON WHERE 65719 GO name class method SQLCLR StoredProcedures SQLCLR StoredProcedures SQLCLR RegexLibrary SQLCLR XSLT SQLCLR SumPrime GetSetIllustrationWebLinks SpTrans MatchAll XSLTransform NULL Notice that the class holding your UDA SumPrime is listed but your UDA itself is not listed. In addition your UDT RegexPattern is not listed. To see everything you rightclick SQLCLR in the Assemblies node of the Object Browser and then select View Dependencies. Summary This chapter covered the development of SQLCLR code using user-defined managed database objects in conjunction with . We also reviewed advanced topics such as transaction control and system catalog viewing. If you attempted the examples from start to finish you have upgraded your SQL Server and .NET programming arsenal and opened the doorway to a new world of data-inte-grated software. In Chapter 47 Using XML in SQL Server 2008 we cover SQL Server s extensive support for XML. CHAPTER 47 Using XML in SQL Server 2008 SqL Server first planted its Extensible Markup Language XML roots with the introduction of the FOR XML and OPENXML keywords in SQL Server 2000 right around the time XML was growing in popularity as a markup format with seemingly unlimited uses. With the release of SQL Server 2008 the bar has clearly been raised for XML support in relational
