SQL Server 2005 Transact-SQL Programming Beginner's Classic

Author: Terry
Publisher:
Publish Date: 2007-01-01
Features: Transact-SQL is a powerful implementation of the ANSI standard SQL database query language. To build efficient database applications, a comprehensive understanding of the functionality of Transact-SQL is required. This book provides a comprehensive introduction to the T-SQL language, demonstrating how to use T-SQL in the SQL Server 2000 and SQL Server 2005 versions. The book first briefly introduces the SQL Server query operations and tools used in T-SQL, then explains in an easy-to-understand manner how to design and build more complex applications. After understanding the powerful capabilities of the T-SQL language, you can meet the growing demands of programming technology. Main Content of the Book● Creating tools using T-SQL to manage hundreds of databases● Various programming techniques using views and stored procedures..● Methods for optimizing query performance● How to create databases as a necessary foundation for future development applicationsTarget Audience of the BookThis book is aimed at database developers and administrators who have not yet used Transact-SQL for procedural programming. If readers have basic knowledge of relational databases and SQL, it will be helpful, and having programming experience is even better...