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