[share_ebook] Transact SQL User Defined Functions

Transact SQL User Defined Functions

Product Description
Transact-SQL doesn’t always offer the functions needed for a project, but with user-defined functions, introduced in Microsoft SQL Server 2000, programmers can create their own. Transact-SQL User-Defined Functions discusses creating, using, and managing user-defined functions and system user-defined functions. The first part of the book explains the SQL syntax required to create, manage, and use UDFs, while the second part describes the system UDFs that Microsoft has added to SQL Server as tools to implement SQL Server functionality.

* Learn to debug UDFs with Query Analyzer and SQL Profiler.

* Retrieve metadata about UDFs with system stored procedures, system functions, INFORMATION_SCHEMA views, and SQL Server’s system tables.

* See UDFs in action with practical examples of currency conversion, unit conversion, report generation, and performance analysis.

* Learn what you can’t do in a user-defined function and why not.

* Discover how to use the documented and undocumented system UDFs.

* Find out how to create your own system UDFs and make them available in all databases.

The sample database in the downloadable files contains a ready-to-use library of over 100 functions and many additional functions that illustrate useful techniques. It also has all the scripts used throughout the chapters so that you can execute the sample code as you read about it.

About the Author
Andrew Novick develops applications as a consultant, project manager, trainer, and principal of Novick Software. His firm specializes in implementing solutions to business operations problems using the Microsoft tool set: SQL Server, ASP, ASP.NET, Visual Basic, and VB .NET. He began programming in high school with a PDP-8 and earned a degree in computer science and an MBA. He has programmed mainframes, minicomputers, and, for the last 17 years, PCs.