ADVANCED TRANSACT-SQL FOR SQL SERVER 2000 – APRESS
In Advanced Transact-SQL for SQL Server 2000, authors Itzik Ben-Gan and saint Moreau explore the coercive capabilities of Transact-SQL (T-SQL). Ben-Gan and Moreau substance solutions to common problems encountered using every versions of SQL Server, with a pore on the stylish version, SQL Server 2000.
Expert tips and actual code examples teach modern database programmers to indite more economical and better-performing cipher that takes flooded advantage of T-SQL. The authors substance practical solutions to the routine problems programmers grappling and include in-depth aggregation on modern T-SQL topics much as joins, subqueries, stored procedures, triggers, user-defined functions (UDFs), indexed views, cascading actions, united views, hierarchic structures, cursors, and more.