Murach's SQL Server 2005 for Developers
How to code aggregate functions and
user-defined types

In this chapter, you'll learn how to use CLR integration to code two types of database objects that aren't available from T-SQL: aggregate functions and user-defined types.
Chapter 21 How to code aggregate functions and user-defined types
How to work with aggregate functions 644
How to declare an aggregate 644
How to work with the SqlUserDefinedAggregate attribute 646
An aggregate that retuns a trimmed average 648
An aggregate that returns a comma-delimited string 652
How to work with user-defined types 656
How to declare a user-defined type 656
How to work with the SqlUserDefinedType attribute 658
A user-defined type for an email address 660
SQL that works with a user-defined type 666
Perspective 668
t


© Copyright 1998-2008 Mike Murach & Associates, Inc.  All rights reserved.

Murach's SQL Server 2005

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.