Beginning T-SQL with Microsoft SQL Server 2005 and 2008

If you've not programmed with Transact-SQL, this book is for you. It begins with an overview of SQL Server query operations and tools used with T-SQL, and covers both the 2005 and 2008 releases of SQL Server query tools and the query editor. The book then moves to show you how to design and bui...

Full description

Bibliographic Details
Main Author: Turley, Paul
Other Authors: Norton, David, Wood, Dan
Format: eBook
Language:English
Published: Indianapolis, Ind. Wiley Pub. 2009
Series:Wrox beginning guides
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
LEADER 03446nmm a2200565 u 4500
001 EB001910985
003 EBX01000000000000001073887
005 00000000000000.0
007 cr|||||||||||||||||||||
008 210123 ||| eng
020 |a 9780470257036 
020 |a 0470257032 
020 |a 1282027972 
020 |a 9781282027978 
020 |a 9780470440483 
020 |a 9786612027970 
020 |a 0470440481 
050 4 |a QA76.73.S67 
100 1 |a Turley, Paul 
245 0 0 |a Beginning T-SQL with Microsoft SQL Server 2005 and 2008  |c Paul Turley and Dan Wood ; technical editor, David Norton 
260 |a Indianapolis, Ind.  |b Wiley Pub.  |c 2009 
300 |a xxiv, 647 pages  |b illustrations 
505 0 |a Chapter 13: Creating and Managing Database ObjectsChapter 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: FileStream Objects and Syntax; Appendix F: Answers to Exercises; Index 
505 0 |a Beginning T-SQL with Microsoft® SQL Server® 2005 and 2008; About the Authors; Credits; Acknowledgments; Contents; 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 
653 |a Client/server computing / fast 
653 |a Bases de données / Gestion 
653 |a Architecture client-serveur (Informatique) 
653 |a SQL server / fast 
653 |a SQL (Langage de programmation) 
653 |a SQL server / http://id.loc.gov/authorities/names/n90684343 
653 |a Database management / http://id.loc.gov/authorities/subjects/sh85035848 
653 |a Client/server computing / http://id.loc.gov/authorities/subjects/sh93000502 
653 |a SQL server / blmlsh 
653 |a Database management / fast 
653 |a SQL (Computer program language) / fast 
653 |a SQL (Computer program language) / http://id.loc.gov/authorities/subjects/sh86006628 
700 1 |a Norton, David 
700 1 |a Wood, Dan 
041 0 7 |a eng  |2 ISO 639-2 
989 |b OREILLY  |a O'Reilly 
490 0 |a Wrox beginning guides 
776 |z 0470257032 
776 |z 9780470440483 
776 |z 0470440481 
776 |z 9780470257036 
776 |z 9780470257036 
856 4 0 |u https://learning.oreilly.com/library/view/~/9780470257036/?ar  |x Verlag  |3 Volltext 
082 0 |a 658 
082 0 |a 005.75/65 
520 |a If you've not programmed with Transact-SQL, this book is for you. It begins with an overview of SQL Server query operations and tools used with T-SQL, and covers both the 2005 and 2008 releases of SQL Server query tools and the query editor. The book then moves to show you how to design and build applications of increasing complexity. Other important tasks covered include full text indexing, optimizing query performance, and application design and security considerations. The companion website also provides all of the code examples from the book