LEADER 03638nam 2200721Ia 450 001 9910810996003321 005 20200520144314.0 010 $a0-470-44049-X 010 $a1-282-02797-2 010 $a9786612027970 010 $a0-470-44048-1 035 $a(CKB)1000000000707398 035 $a(EBL)427667 035 $a(OCoLC)646796210 035 $a(SSID)ssj0000109927 035 $a(PQKBManifestationID)11125179 035 $a(PQKBTitleCode)TC0000109927 035 $a(PQKBWorkID)10059539 035 $a(PQKB)11393473 035 $a(Au-PeEL)EBL427667 035 $a(CaPaEBR)ebr10275694 035 $a(CaONFJC)MIL202797 035 $a(CaSebORM)9780470257036 035 $a(MiAaPQ)EBC427667 035 $a(OCoLC)741517536 035 $a(OCoLC)ocn741517536 035 $a(OCoLC)216937245 035 $a(FINmELB)ELB178285 035 $a(EXLCZ)991000000000707398 100 $a20090410d2009 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aBeginning T-SQL with Microsoft SQL Server 2005 and 2008 /$fPaul Turley and Dan Wood ; technical editor, David Norton 205 $a1st edition 210 $aIndianapolis, Ind. $cWiley Publishing, Inc.$dc2009 215 $a1 online resource (675 p.) 225 1 $aWrox beginning guides. 300 $aIncludes index. 311 $a0-470-25703-2 327 $aBeginning 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 327 $aChapter 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 330 $aIf 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. 410 0$aWrox beginning guides. 606 $aClient/server computing 606 $aDatabase management 606 $aSQL (Computer program language) 615 0$aClient/server computing. 615 0$aDatabase management. 615 0$aSQL (Computer program language) 676 $a005.7585 700 $aTurley$b Paul$f1962-$0850105 701 $aNorton$b David$0551022 701 $aWood$b Dan$f1962-$01706734 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910810996003321 996 $aBeginning T-SQL with Microsoft SQL Server 2005 and 2008$94094405 997 $aUNINA