| |
|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNINA9910782658803321 |
|
|
Autore |
Turley Paul <1962-> |
|
|
Titolo |
Beginning T-SQL with Microsoft SQL Server 2005 and 2008 [[electronic resource] /] / Paul Turley and Dan Wood ; technical editor, David Norton |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Indianapolis, Ind., : Wiley Publishing, Inc., c2009 |
|
|
|
|
|
|
|
ISBN |
|
0-470-44049-X |
1-282-02797-2 |
9786612027970 |
0-470-44048-1 |
|
|
|
|
|
|
|
|
Edizione |
[1st edition] |
|
|
|
|
|
Descrizione fisica |
|
1 online resource (675 p.) |
|
|
|
|
|
|
Collana |
|
|
|
|
|
|
Altri autori (Persone) |
|
NortonDavid |
WoodDan <1962-> |
|
|
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
Client/server computing |
Database management |
SQL (Computer program language) |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
|
|
|
|
|
Nota di contenuto |
|
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 |
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Sommario/riassunto |
|
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. |
|
|
|
|
|
|
|
| |