|
|
Transact-SQL User-Defined Functions
Published by Wordware
November 10, 2003 - For Immediate Release
Novick Software is pleased to
announce the publication of
Transact-SQL User-Defined
Functions by Wordware
Publishers of Plano Texas. The book is available at major book
stores, such as Barnes and Noble, web sites, such as Amazon.com
and directly from Novick Software at
www.NovickSoftware.com.
Transact-SQL User-Defined
Functions is the first and only book to cover the User-Defined
Functions (UDFs)capability of SQL Server.
UDFs were introduced in the SQL Server 2000 version. This is the first book to give
extensive coverage to this new and important capability. A
capability that every Database ADministrator (DBA) and programmer
working with SQL Server should be using. But no other book offers
more than a chapter on UDFs and a half a dozen examples. This book
gives extensive coverage to all aspects of creating, using, and
managing UDFs. It includes over one hundred functions with detailed
examples of how each one can be used effectively.
Trnasact-SQL
User-Defined Functions
describes how to use and construct UDFs. UDFs
are an extension to the Transact-SQL language that is the API to SQL
Server. It shows how functions are integrated into the language and
which T-SQL statements can be used to construct them.
The book is divided into nineteen
chapters in two parts. The first part discusses the ins and outs of
User-Defined Functions (UDF). It starts with a gentile introduction
and then builds on that by adding detailed on each of the three
types of UDF. It goes on to discuss conventions and best practices
for security, naming conventions, formatting, and documenting UDFs.
There are chapters devoted to working with extended stored
procedures, OLE automation, and testing for correctness and
performance. The limitations of UDFs are detailed in the chapter,
You Cant Do That with a UDF. The first part concludes with two
chapters describing real-world examples showing how UDFs can be a
vital component of an application.
The second part of the book is
devoted to the system UDFs, which are supplied as part of SQL
Server. These UDFs have a special status that allows them
additional functionality and requires their own syntax. System UDFs
are introduced, explained, and then used to build new functions that
turn their raw data into useful information. Thorough examples are
given demonstrating how to use each UDF. Additional chapters in the
second part are devoted to the undocumented system UDFs and to a
technique for adding new system UDFs.
The download that accompanies the
book contains source code from
the examples and additional user-defined functions, stored
procedures, visual- basic example code, SQL scripts, and
documentation.
|
|
