Advanced Transact−SQL for SQL Server 2000
✍ Scribed by Kalen Delaney
- Book ID
- 127445745
- Publisher
- Microsoft Press
- Year
- 2000
- Tongue
- English
- Weight
- 3 MB
- Category
- Library
- ISBN-13
- 9780735609983
No coin nor oath required. For personal study only.
✦ Synopsis
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.
📜 SIMILAR VOLUMES
This is the definitive companion to Microsoft SQL Server 2000. The authors have combined the perspectives of the developer and the user into a readable and comprehensive guide. Ron Soukup led the SQL Server development team for a decade, and he continues to be one of its key architects. Kalen Delane
Das Buch erläutert Datenbankprogrammierern, Systemadministratoren und Endbenutzern die diversen Komponenten des SQL Servers und zeigt ihre Zusammenhänge auf. Schwerpunkte sind: SQL-Anweisungen, Sicherheits- und Integritätskonzept des SQL Servers, Data-Warehousing-Komponenten und Analysis Services. I
This guide offers advanced advice on tuning the server, optimizing administration tasks through automation, and deploying SQL server in the Enterprise environment.
Improve functionality and develop robust SQL Server applications with confidence using this collection of pre-written solutions. Best-selling programming author Greg Buczek brings you the most authoritative and useful collection of expert techniques and ready-to-use applications available.
XML and SQL Server 2000 will enable SQL developers to understand and work with XML, the preferred technology for integrating eBusiness systems. This book will provide a comprehensive discussion of SQL Server 2000's XML capabilities. There is a brief discussion in the first two chapters on XSL/XSLT a