Murach's SQL Server 2008 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 22 How to code aggregate functions and user-defined types
How to work with aggregate functions 714
How to declare an aggregate 714
How to work with the SqlUserDefinedAggregate attribute 716
An aggregate that retuns a trimmed average 718
An aggregate that returns a comma-delimited string 722
How to work with user-defined types 726
How to declare a user-defined type 726
How to work with the SqlUserDefinedType attribute 728
A user-defined type for an email address 730
SQL that works with a user-defined type 736
t


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

Murach's SQL Server 2008

Learn more about this book

View the table of contents


More about the eBook



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.