Overview
Provides hundreds of solutions to common problems encountered by SQL Server programmers
Both authors write regularly for SQL Server Magazine and Pinnacle Publishing's Microsoft SQL Server Professional newsletter
Includes expert tips and plenty of real code examples
Presents differences between SQL Server 2000 and version 6.X and 7.0
Includes supplementary material: sn.pub/extras
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (18 chapters)
Keywords
About this book
In Advanced Transact-SQL for SQL Server 2000, authors Itzik Ben-Gan and Thomas Moreau explore the powerful capabilities of Transact-SQL (T-SQL). Ben-Gan and Moreau offer solutions to common problems encountered using all versions of SQL Server, with a focus on the latest version, SQL Server 2000.
Expert tips and real code examples teach advanced database programmers to write more efficient and better-performing code that takes full advantage of T-SQL. The authors offer practical solutions to the everyday problems programmers face and include in-depth information on advanced T-SQL topics such as joins, subqueries, stored procedures, triggers, user-defined functions (UDFs), indexed views, cascading actions, federated views, hierarchical structures, cursors, and more.
About the authors
Bibliographic Information
Book Title: Advanced Transact-SQL for SQL Server 2000
Authors: Itzik Ben-Gan, Tom Moreau
DOI: https://doi.org/10.1007/978-1-4302-0859-4
Publisher: Apress Berkeley, CA
-
eBook Packages: Springer Book Archive
Copyright Information: Itzik Ben-Gan and Tom Moreau 2000
Softcover ISBN: 978-1-893115-82-8Published: 28 November 2000
eBook ISBN: 978-1-4302-0859-4Published: 01 January 2008
Edition Number: 1
Number of Pages: XLII, 864
Topics: Database Management, Software Engineering/Programming and Operating Systems