Transact SQL User Defined Functions
 |
|
Описание:
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. * Find out about the three types of UDFs and how to create and use them. * 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...Похожие книги
 | Building Websites with XOOPS Автор: Steve Atwal Год: 2006 |
| JavaFX Special Effects: Taking Java RIA to the Extreme with Animation, Multimedia, and Game Elements (Beginning) Автор: Lucas Jordan Год: 2009 |
 | Silverlight 2 Unleashed Автор: Laurent Bugnion Год: 2008 |
 | Practical C# Charts and Graphics Автор: Jack Xu Год: 2007 |
| Pro Crystal Enterprise / BusinessObjects XI Programming (v. 11 Автор: Jr., Carl Ganz Год: 2006 |
| Flash® Professional CS5 Digital ClassroomTM Автор: Fred Gerantabee Год: 2010 |