Transact SQL User Defined Functions
Andrew NovickISBN: 1556220790;
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...
- OZON.ru 3315