SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach
When it comes to performing your daily SQL Server tasks, technical documentation tends to tell you more than you need to know. Let’s say that you’re in a hurry, and you want to add a unique constraint to a table before someone inserts a duplicate value into it. Where do you look? One obvious choice...
Đã lưu trong:
| Tác giả chính: | |
|---|---|
| Định dạng: | Sách |
| Ngôn ngữ: | English |
| Được phát hành: |
Apress
2013
|
| Những chủ đề: | |
| Truy cập trực tuyến: | https://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/34777 |
| 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-34777 |
|---|---|
| record_format |
dspace |
| institution |
Thư viện Trường Đại học Đà Lạt |
| collection |
Thư viện số |
| language |
English |
| topic |
SQL Computer |
| spellingShingle |
SQL Computer Sack, Sack SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach |
| description |
When it comes to performing your daily SQL Server tasks, technical documentation tends to tell you more than you need to know.
Let’s say that you’re in a hurry, and you want to add a unique constraint to a table before someone inserts a duplicate value into it. Where do you look? One obvious choice is SQL Server Books Online. With its massive amounts of useful information,
you know that the answer has to be there somewhere. Unfortunately, finding this information may involve several click-throughs and red herrings. Once you do arrive at the correct page, the information you need may be integrated into a larger syntax block, with unrelated functionality or
examples. SQL Server 2005 T-SQL Recipes was written in order to address the need for fast information retrieval and use. Topics are presented in a task-based format. Each topic (recipe) provides the necessary background to get you started, presents one or more examples, and then concisely
explains how it all works. Whether you need to brush up on a topic you haven’t used for a while, or whether you’re new to Transact-SQL, you can easily pick and choose the areas you need to work on. This book
covers the basics and beyond, demonstrating the more complex techniques and functionality
offered in SQL Server 2005’s flavor of Transact-SQL. Want to learn more about what’s new in SQL Server 2005? This book will also demonstrate the new Transact-SQL features and functionality introduced in SQL Server 2005, allowing you to quickly test out features with aminimal amount of fuss.
Written to be index-friendly, the book does not need to be read front to back in order for readers to benefit from it. Whether you are a novice, part-time, or seasoned SQL Server professional, SQL Server 2005 T-SQL Recipes will provide you with the fast facts needed to help you get the job done. |
| format |
Book |
| author |
Sack, Sack |
| author_facet |
Sack, Sack |
| author_sort |
Sack, Sack |
| title |
SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach |
| title_short |
SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach |
| title_full |
SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach |
| title_fullStr |
SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach |
| title_full_unstemmed |
SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach |
| title_sort |
sql server 2005 t-sql recipes: a problem-solution approach |
| publisher |
Apress |
| publishDate |
2013 |
| url |
https://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/34777 |
| _version_ |
1819789504436764672 |
| spelling |
oai:scholar.dlu.edu.vn:DLU123456789-347772014-01-20T01:40:58Z SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach Sack, Sack SQL Computer When it comes to performing your daily SQL Server tasks, technical documentation tends to tell you more than you need to know. Let’s say that you’re in a hurry, and you want to add a unique constraint to a table before someone inserts a duplicate value into it. Where do you look? One obvious choice is SQL Server Books Online. With its massive amounts of useful information, you know that the answer has to be there somewhere. Unfortunately, finding this information may involve several click-throughs and red herrings. Once you do arrive at the correct page, the information you need may be integrated into a larger syntax block, with unrelated functionality or examples. SQL Server 2005 T-SQL Recipes was written in order to address the need for fast information retrieval and use. Topics are presented in a task-based format. Each topic (recipe) provides the necessary background to get you started, presents one or more examples, and then concisely explains how it all works. Whether you need to brush up on a topic you haven’t used for a while, or whether you’re new to Transact-SQL, you can easily pick and choose the areas you need to work on. This book covers the basics and beyond, demonstrating the more complex techniques and functionality offered in SQL Server 2005’s flavor of Transact-SQL. Want to learn more about what’s new in SQL Server 2005? This book will also demonstrate the new Transact-SQL features and functionality introduced in SQL Server 2005, allowing you to quickly test out features with aminimal amount of fuss. Written to be index-friendly, the book does not need to be read front to back in order for readers to benefit from it. Whether you are a novice, part-time, or seasoned SQL Server professional, SQL Server 2005 T-SQL Recipes will provide you with the fast facts needed to help you get the job done. About the Author. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxiii About the Technical Reviewer. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxv Acknowledgments. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxvii Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxix ■CHAPTER 1 SELECT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 ■CHAPTER 2 INSERT, UPDATE, DELETE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61 ■CHAPTER 3 Transactions, Locking, Blocking, and Deadlocking . . . . . . . . . . . . . . 83 ■CHAPTER 4 Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109 ■CHAPTER 5 Indexes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155 ■CHAPTER 6 Full-Text Search . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 173 ■CHAPTER 7 Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 191 ■CHAPTER 8 SQL Server Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 209 ■CHAPTER 9 Conditional Processing, Control-Of-Flow, and Cursors. . . . . . . . . . 255 ■CHAPTER 10 Stored Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 271 ■CHAPTER 11 User-Defined Functions and Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . 289 ■CHAPTER 12 Triggers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 313 ■CHAPTER 13 CLR Integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 337 ■CHAPTER 14 XML. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 355 ■CHAPTER 15 Web Services. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 375 ■CHAPTER 16 Error Handling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 393 ■CHAPTER 17 Principals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 407 ■CHAPTER 18 Securables and Permissions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 433 ■CHAPTER 19 Encryption. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 459 ■CHAPTER 20 Service Broker . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 485 ■CHAPTER 21 Configuring and Viewing SQL Server Options . . . . . . . . . . . . . . . . . . 517 ■CHAPTER 22 Creating and Configuring Databases . . . . . . . . . . . . . . . . . . . . . . . . . . 523 ■CHAPTER 23 Database Integrity and Optimization. . . . . . . . . . . . . . . . . . . . . . . . . . . 571 ■CHAPTER 24 Maintaining Database Objects and Object Dependencies. . . . . . . 589 ■CHAPTER 25 Database Mirroring . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 595 ■CHAPTER 26 Database Snapshots . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 615 ■CHAPTER 27 Linked Servers and Distributed Queries . . . . . . . . . . . . . . . . . . . . . . . 621 ■CHAPTER 28 Performance Tuning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 637 ■CHAPTER 29 Backup and Recovery. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 683 INDEX. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 717 2013-07-18T08:18:05Z 2013-07-18T08:18:05Z 2006 Book 1-59059-570-X https://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/34777 en application/pdf Apress |