没有合适的资源?快使用搜索试试~ 我知道了~
首页Beginning Microsoft SQL Server 2008 Programming.
Beginning Microsoft SQL Server 2008 Programming.
5星 · 超过95%的资源 需积分: 10 78 下载量 153 浏览量
更新于2023-03-03
评论
收藏 13.86MB PDF 举报
great introduction to sqlserver 2008 learn more as you read more NOTICE eng-version
资源详情
资源评论
资源推荐
Beginning
Microsoft
®
SQ L Se rver
®
20 08
Programming
Enhance Your Knowledge
Advance Your Career
Professional Mic rosoft SQL Ser ver 2008
Integration Services
978-0-470-24795-2
This book shows developers how to master the 2008 release of SSIS,
covering topics including data warehousing with SSIS, new methods of
managing the SSIS platform, and improved techniques for ETL operations.
Professional SQL Ser ver 20 08 Reporting Ser vices
978-0-470-24201-8
This book teaches solutions architects, designers, and developers how
to use Microsoft’s reporting platform to create reporting and business
intelligence solutions.
Professional Mic rosoft SQL Ser ver 2008
Analysis Services
978-0-470-24798-3
Professional Microsoft SQL Server 2008 Analysis Services shows readers
how to build data warehouses and multidimensional databases, query
databases, and use Analysis Services and other components of SQL
Server to provide end-to-end solutions.
Professional Mic rosoft SQL Ser ver 2008 Programming
978-0-470-25702-9
This updated new edition of Wrox’s best-selling SQL Server book has been
expanded to include coverage of SQL Server 2008’s new datatypes, new
indexing structures, manageability features, and advanced time-zone
handling.
Professional Mic rosoft SQL Server 2008 A dministration
978-0-470-24796-9
A how-to guide for experienced database administrators, this book is
loaded with unique tips, tricks, and workarounds for handling the most difficult SQL Server administration issues. The authors
discuss data capture, performance studio, Query Governor, and new techniques for monitoring and policy management.
Beginning T-SQL with Mic rosoft SQ L Ser ver 20 05 a nd 2008
978-0-470-25703-6
Beginning T-SQL with Microsoft SQL Server 2005 and 2008 provides a comprehensive introduction to the T-SQL programming
language, with concrete examples showing how T-SQL works with both SQL Server 2005 and SQL Server 2008.
Beginning Database Design Solution s
978-0-470-38549-4
Beginning Database Design Solutions introduces IT professionals—both DBAs and database developers—to database design.
It explains what databases are, their goals, and why proper design is necessary to achieve those goals. It tells how to decide
what should be in a database to meet the application’s requirements. It tells how to structure the database so it gives good
performance while minimizing the chance for error.
Get more out of
WROX.com
Programmer to Programmer
™
Interact
Take an active role online by participating in
our P2P forums
Wrox Online Library
Hundreds of our books are available online
through Books24x7.com
Wrox Blox
Download short informational pieces and
code to keep you up to date and out of
trouble!
Chapters on Demand
Purchase individual book chapters in pdf
format
Join the Community
Sign up for our free monthly newsletter at
newsletter.wrox.com
Browse
Ready for more Wrox? We have books and
e-books available on .NET, SQL Server, Java,
XML, Visual Basic, C#/ C++, and much more!
Contact Us.
We always like to get feedback from our readers. Have a book idea?
Need community support? Let us know by e-mailing wrox-partnerwithus@wrox.com
Beginning Microsoft SQL Ser ver® 2008
Programming
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxxi
Chapter 1: RDBMS Basics: What Mak es Up a SQL Ser ver Database? . . . . . . . 1
Chapter 2: T ools of the T rade . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
Chapter 3: The F oundation Statements of T -SQL . . . . . . . . . . . . . . . . . . . . . . 43
Chapter 4: JOINs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81
Chapter 5: Creating and Altering T ables . . . . . . . . . . . . . . . . . . . . . . . . . . . 113
Chapter 6: Constraints . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153
Chapter 7: Adding More to Our Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . 187
Chapter 8: Being Nor mal: Normalization and Other Basic Design Issues. . . . 215
Chapter 9: SQL Ser ver Storage and Index Str uctures . . . . . . . . . . . . . . . . . 261
Chapter 10: V iews . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 299
Chapter 11: Writing Scripts and Batches . . . . . . . . . . . . . . . . . . . . . . . . . . 325
Chapter 12: Stored Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 367
Chapter 13: User-Defined Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 411
Chapter 14: T ransactions and Locks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 427
Chapter 15: T riggers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 451
Chapter 16: A Brief XML Primer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 473
Chapter 17: Repor ting for Duty, Sir! A Look At Repor ting Ser vices . . . . . . . 517
Chapter 18: Getting Integrated with Integration Ser vices . . . . . . . . . . . . . . 543
Chapter 19: Pla ying Administrator . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 563
Appendix A: System Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 587
Appendix B: V ery Simple Connectivity Examples . . . . . . . . . . . . . . . . . . . . . 649
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 657
57012ffirs.qxd:WroxBeg 11/24/08 4:52 PM Page i
57012ffirs.qxd:WroxBeg 11/24/08 4:52 PM Page ii
Beginning
Microsoft SQL Ser ver® 2008 Programming
57012ffirs.qxd:WroxBeg 11/24/08 4:52 PM Page iii
剩余721页未读,继续阅读
wintelbailu
- 粉丝: 1
- 资源: 13
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- RTL8188FU-Linux-v5.7.4.2-36687.20200602.tar(20765).gz
- c++校园超市商品信息管理系统课程设计说明书(含源代码) (2).pdf
- 建筑供配电系统相关课件.pptx
- 企业管理规章制度及管理模式.doc
- vb打开摄像头.doc
- 云计算-可信计算中认证协议改进方案.pdf
- [详细完整版]单片机编程4.ppt
- c语言常用算法.pdf
- c++经典程序代码大全.pdf
- 单片机数字时钟资料.doc
- 11项目管理前沿1.0.pptx
- 基于ssm的“魅力”繁峙宣传网站的设计与实现论文.doc
- 智慧交通综合解决方案.pptx
- 建筑防潮设计-PowerPointPresentati.pptx
- SPC统计过程控制程序.pptx
- SPC统计方法基础知识.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论13