SQL Server 2005 Transact-SQL Programming Beginner's Guide

Author: Liu Ying
Publisher:
Publish Date: Not available
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 features 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 for views and stored procedures
● Methods to optimize query performance
● How to create databases as a necessary foundation for future application development
Target Audience of the Book
This book is intended for 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...