2008, ISBN: 4641f6e93d9ffc0b004eaf0b0580da65

Wiley India Pvt. Ltd, 2009. Softcover. New. Transact-SQL (referred to as T-SQL) is Microsoft`s implementation of the SQL database query language; all developers and users of the Microso… More...

Wiley India Pvt. Ltd, 2009. Softcover. New. Transact-SQL (referred to as T-SQL) is Microsoft`s implementation of the SQL database query language; all developers and users of the Microsoft SQL Server database must use T-SQL to interact with the database. T-SQL represents the jump-on point for SQL Server users and is core to nearly all of its features. Regardless of their objectives and direction, every SQL Server user must master the T-SQL language. This book will serve this large audience by covering all of the mainstream topics. It will provide business cases, background and direction as well as tutorials and a comprehensive reference. Though T-SQL is based on the standard SQL language, it has many features that are unique. In addition, the SQL Server product has built-in query tools that work only with T-SQL. Microsoft database programmers must understand these unique features in order to build effective database applications. Although there are hundreds of books on SQL, there are surprisingly few on T-SQL, and most are now out of date (and many are poorly reviewed) --only a few are likely to be updated for SQL Server 2008. Wrox Press` Beginning T-SQL Programming will provide a comprehensive introduction to the T-SQL language, and show how it can be used to work with both the SQL Server 2005 and 2008 releases. Though there are few syntax differences between the 2005 and 2008 releases, there are new features and optimizations that impact T-SQL. Introduction · Chapter 1: Introducing T-SQL and Data Management Systems · Chapter 2: SQL Server Fundamentals · Chapter 3: SQL Server Tools · Chapter 4: Introducing the T-SQL Language · Chapter 5: Data Retrieval · Chapter 6: SQL Functions · Chapter 7: Aggregation and Grouping · Chapter 8: Multi-Table Queries · Chapter 9: Advanced Queries and Scripting · Chapter 10: Transactions · Chapter 11: Advanced Capabilities · Chapter 12: T-SQL Programming Objects · Chapter 13: Creating and Managing Database Objects · Chapter 14: Analyzing and Optimizing Query Performance · Chapter 15: T-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: File Stream Objects and Syntax Appendix F: Answers to Exercises Index Printed Pages: 672., Wiley India Pvt. Ltd, 2009<