Pro T-SQL 2008 Programmer’s Guide

This book was originally scheduled to be an update of my Pro T-SQL 2005 Programmer’s Guide book. The sheer number of new features, however, demanded a nearly complete rewrite.I designed this new book with the goal of helping T-SQL developers get the absolute most out of the exciting new development...

Mô tả đầy đủ

Đã lưu trong:

Chi tiết về thư mục
Tác giả chính:	Coles, Michael
Định dạng:	Sách
Ngôn ngữ:	English
Được phát hành:	Apress 2012
Những chủ đề:	SQL Technologies
Truy cập trực tuyến:	http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/31796
Các nhãn:	Thêm thẻ Không có thẻ, Là người đầu tiên thẻ bản ghi này!

Thư viện lưu trữ:	Thư viện Trường Đại học Đà Lạt

id	oai:scholar.dlu.edu.vn:DLU123456789-31796
record_format	dspace
spelling	oai:scholar.dlu.edu.vn:DLU123456789-317962014-01-20T04:29:25Z Pro T-SQL 2008 Programmer’s Guide Coles, Michael SQL Technologies This book was originally scheduled to be an update of my Pro T-SQL 2005 Programmer’s Guide book. The sheer number of new features, however, demanded a nearly complete rewrite.I designed this new book with the goal of helping T-SQL developers get the absolute most out of the exciting new development features and functionality in SQL Server 2008. n CHAPTER 1 Foundations of T-SQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 n CHAPTER 2 T-SQL 2008 New Features . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 n CHAPTER 3 Tools of the Trade . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61 n CHAPTER 4 Procedural Code and CASE Expressions . . . . . . . . . . . . . . . . . . 81 n CHAPTER 5 User-Defined Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117 n CHAPTER 6 Stored Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151 n CHAPTER 7 Triggers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 187 n CHAPTER 8 Encryption . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 219 n CHAPTER 9 Common Table Expressions and Windowing Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 247 n CHAPTER 10 Integrated Full-Text Search . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 273 n CHAPTER 11 XML . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 299 n CHAPTER 12 XQuery and XPath . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 341 n CHAPTER 13 Catalog Views and Dynamic Management Views . . . . . . . 387 n CHAPTER 14 SQL CLR Programming . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 407 n CHAPTER 15 .NET Client Programming . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 451 n CHAPTER 16 Data Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 495 n CHAPTER 17 New T-SQL Features . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 525 n CHAPTER 18 Error Handling and Dynamic SQL . . . . . . . . . . . . . . . . . . . . . . . . . 553n CHAPTER 19 Performance Tuning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 573 n APPENDIX A Exercise Answers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 603 n APPENDIX B XQuery Data Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 613 n APPENDIX C Glossary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 619 n APPENDIX D SQLCMD Quick Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 631 n INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 639 2012-09-12T01:11:23Z 2012-09-12T01:11:23Z 2008 Book 978-1-4302-1001-6 http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/31796 en application/pdf Apress
institution	Thư viện Trường Đại học Đà Lạt
collection	Thư viện số
language	English
topic	SQL Technologies
spellingShingle	SQL Technologies Coles, Michael Pro T-SQL 2008 Programmer’s Guide
description	This book was originally scheduled to be an update of my Pro T-SQL 2005 Programmer’s Guide book. The sheer number of new features, however, demanded a nearly complete rewrite.I designed this new book with the goal of helping T-SQL developers get the absolute most out of the exciting new development features and functionality in SQL Server 2008.
format	Book
author	Coles, Michael
author_facet	Coles, Michael
author_sort	Coles, Michael
title	Pro T-SQL 2008 Programmer’s Guide
title_short	Pro T-SQL 2008 Programmer’s Guide
title_full	Pro T-SQL 2008 Programmer’s Guide
title_fullStr	Pro T-SQL 2008 Programmer’s Guide
title_full_unstemmed	Pro T-SQL 2008 Programmer’s Guide
title_sort	pro t-sql 2008 programmer’s guide
publisher	Apress
publishDate	2012
url	http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/31796
_version_	1757674911586844672

Pro T-SQL 2008 Programmer’s Guide

Những quyển sách tương tự