| |
SQL Server 2000 is the latest and most powerful version of Microsoft`s data warehousing and relational database management system. This new release is tightly integrated with Windows 2000 and offers more support for XML, as well as improved Analysis Services for OLAP and data mining.Professional SQL Server 2000 provides a comprehensive guide to programming with SQL Server 2000, from a complete tutorial on TransactSQL to an indepth discussion of new features, such as indexed views, userdefined functions, and the wealth of new SQL Server features to support XML. Whether you`re coming to SQL Server 2000 from another relational database management system, upgrading your existing system, or perhaps wanting to add programming skills to your DBA knowledge, you`ll find what you need in this book to get to grips with SQL Server 2000 development.Who is this book for?This book is aimed at the SQL Server developer who wants to make the most out of the new features of SQL Server 2000. No knowledge of SQL Server is assumed, although in order to follow this book, you do need to have an understanding of programming basics such as variables, data types, and procedural programming. Database administration is also covered but only as it affects the SQL Server developer.What does this book cover?A complete introduction to TransactSQLDatabase design issuesCreating and using views, stored procedures, and user defined functionsResponding to events with triggersMaking your SQL Server secureRetrieving your data as XMLAn introduction to Analysis ServicesMoving data using Data Transformation Services and the bulk copy programMaintaining the integrity of distributed data with replication
|
| |
|