Beginning Transact-SQL with SQL Server 2000 and 2005

Paul Turley, Dan Wood - Collection Programmer to Programmer

570 pages, parution le 10/11/2005

Ajouter à une liste

Indisponible

Résumé

Transact-SQL is a powerful implementation of the ANSI standard SQL database query language. In order to build effective database applications, you must gain a thorough understanding of these features. This book provides you with a comprehensive introduction to the T-SQL language and shows you how it can be used to work with both the SQL Server 2000 and 2005 releases.

Beginning with an overview of the SQL Server query operations and tools that are used with T-SQL, the author goes on to explain how to design and build applications of increasing complexity. By gaining an understanding of the power of the T-SQL language, you'll be prepared to meet the ever-increasing demands of programming.

What you will learn from this book

How T-SQL provides you with the means to create tools for managing hundreds of databases
Various programming techniques that use views and stored procedures
Ways to optimize query performance
How to create databases that will be an essential foundation to applications you develop later

Who this book is for

This book is for database developers and administrators who have not yet programmed with Transact-SQL. Some familiarity with relational databases and basic SQL is helpful, and some programming experience is helpful.

Sommaire

Introducing Transact SQL and Data Management Systems
SQL Server Fundamentals
Tools for Accessing SQL Server
Introducing Transact-SQL Language
Data Retrieval
SQL Functions
Aggregation and Grouping
Multi-Table Queries
Data Transactions
Advanced Queries and Scripting
Full-Text Index Queries
Creating and Managing Database Objects
Transact-SQL Programming Objects
Transact-SQL in Applications and Reporting
Appendix A: Command Syntax Reference
Appendix B: System Variables and Functions Reference
Appendix C: System Stored Procedure Reference
Appendix D: Information Schema Views Reference
Appendix E: Answers to Exercises
Index

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wrox Press
Auteur(s)	Paul Turley, Dan Wood
Collection	Programmer to Programmer
Parution	10/11/2005
Nb. de pages	570
Format	18,5 x 23,5
Couverture	Broché
Poids	893g
Intérieur	Noir et Blanc
EAN13	9780764579554
ISBN13	978-0-7645-7955-4