Pro T-SQL 2005 Programmer’s Guide

This book examines SQL Server 2005 T-SQL from a developer’s perspective. It covers a wide range of developer-specific topics in SQL Server 2005, from an introduction to new developer tools such as SQLCMD and SQL Server Management Studio to new T-SQL functionality such as the xml data type, XQuery...

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/31794
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-31794
record_format	dspace
spelling	oai:scholar.dlu.edu.vn:DLU123456789-317942014-01-19T08:34:27Z Pro T-SQL 2005 Programmer’s Guide Coles, Michael SQL Technologies This book examines SQL Server 2005 T-SQL from a developer’s perspective. It covers a wide range of developer-specific topics in SQL Server 2005, from an introduction to new developer tools such as SQLCMD and SQL Server Management Studio to new T-SQL functionality such as the xml data type, XQuery support, and T-SQL encryption. n CHAPTER 1 The Role of T-SQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 n CHAPTER 2 Tools of the Trade . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 n CHAPTER 3 T-SQL for SQL Server 2000 Programmers . . . . . . . . . . . . . . . . . . . . . . 33 n CHAPTER 4 Control-of-Flow and CASE Expressions . . . . . . . . . . . . . . . . . . . . . . . . . 63 n CHAPTER 5 User-Defined Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87 n CHAPTER 6 Stored Procedures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117 n CHAPTER 7 Triggers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143 n CHAPTER 8 T-SQL Encryption . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 175 n CHAPTER 9 Error Handling and Debugging . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 203 n CHAPTER 10 Dynamic SQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 215 n CHAPTER 11 XML . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 227 n CHAPTER 12 XQuery and XPath . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 273 n CHAPTER 13 SQL Metadata . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 323 n CHAPTER 14 SQLCLR Programming . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 343 n CHAPTER 15 .NET Client Programming . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 379 n CHAPTER 16 HTTP Endpoints. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 411 n APPENDIX A T-SQL Keywords. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 439 n APPENDIX B XQuery Data Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 451 n APPENDIX C XQuery Terms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 457 n APPENDIX D Selected T-SQL Source Code Listings . . . . . . . . . . . . . . . . . . . . . . . . . 463 n APPENDIX E .NET Source Code Listings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 483 n INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 511 2012-09-12T01:03:56Z 2012-09-12T01:03:56Z 2005 Book 978-1-59059-794-1 http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/31794 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 2005 Programmer’s Guide
description	This book examines SQL Server 2005 T-SQL from a developer’s perspective. It covers a wide range of developer-specific topics in SQL Server 2005, from an introduction to new developer tools such as SQLCMD and SQL Server Management Studio to new T-SQL functionality such as the xml data type, XQuery support, and T-SQL encryption.
format	Book
author	Coles, Michael
author_facet	Coles, Michael
author_sort	Coles, Michael
title	Pro T-SQL 2005 Programmer’s Guide
title_short	Pro T-SQL 2005 Programmer’s Guide
title_full	Pro T-SQL 2005 Programmer’s Guide
title_fullStr	Pro T-SQL 2005 Programmer’s Guide
title_full_unstemmed	Pro T-SQL 2005 Programmer’s Guide
title_sort	pro t-sql 2005 programmer’s guide
publisher	Apress
publishDate	2012
url	http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/31794
_version_	1757673595989917696

Pro T-SQL 2005 Programmer’s Guide

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