menu 简单麦麦
account_circle

SQL Server 2008 Transact-SQL配方:一种问题解决方法-SQL Server 2008 Transact-SQL Recipes: A Problem-Solution App文件编号:1636

已经帮助了2549人找到了他们想要的文件
上传于 2020年2月27日 23:34
16次下载
2154次围观
评分:4.5/5 ★ ★ ★ ★ ★
标题(title):SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach
SQL Server 2008 Transact-SQL配方:一种问题解决方法
作者(author):Joseph Sack
出版社(publisher):apress
大小(size):7 MB (7119238 bytes)
格式(extension):pdf
注意:如果文件下载完成后为无法打开的格式,请修改后缀名为格式对应后缀


SQL Server 2008 Transact–SQL Recipes: A Problem–Solution Approach is an example–based guide to the Transact–SQL language that is at the core of SQL Server 2008. Learn to create databases, insert and update data, generate reports, secure your data, and more. Author Joseph Sack takes common Transact–SQL tasks and breaks them down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on.
Focused on solutions: Look up what you need to do. Learn how to do it. Do it. Current: Newly updated for SQL Server 2008. Comprehensive: Covers 30 different Transact–SQL problem domains. What you’ll learn Create databases, tables, and indexes. Query and manipulate data. Store and manage XML inside the database. Move business logic into the database. Encrypt data and capture changes for compliance purposes. Implement Full–Text Search. Interface with Service Broker. And more! Who is this book for?
Developers who use Microsoft SQL Server 2008 as their back–end database. Database administrators who create, manage, and secure those databases.

Table of contents :
SQL Server 2008 Transact-SQL Recipes......Page 1
Contents at a Glance......Page 6
Contents......Page 9
About the Author......Page 27
About the Technical Reviewer......Page 29
Acknowledgments......Page 31
Introduction......Page 33
The Basic SELECT Statement......Page 35
How It Works......Page 36
Selective Querying Using a Basic WHERE Clause......Page 37
Combining Search Conditions......Page 38
How It Works......Page 39
Keeping Your WHERE Clause Unambiguous......Page 40
Using Operators and Expressions......Page 41
Using Comparisons......Page 43
How It Works......Page 44
Using Wildcards with LIKE......Page 45
Declaring and Assigning Values to Variables......Page 46
How It Works......Page 47
How It Works......Page 48
Using GROUP BY ALL......Page 49
Selectively Querying Grouped Data Using HAVING......Page 50
Using the ORDER BY Clause......Page 51
How It Works......Page 52
Using the TOP Keyword with Ordered Results......Page 53
How It Works......Page 54
Using DISTINCT to Remove Duplicate Values......Page 55
Using Column Aliases......Page 56
Using SELECT to Create a Script......Page 57
Performing String Concatenation......Page 58
How It Works......Page 59
Using the INTO Clause......Page 60
Using Subqueries to Check for Matches......Page 61
Querying from More Than One Data Source......Page 62
How It Works......Page 63
Using OUTER Joins......Page 64
Using CROSS Joins......Page 65
How It Works......Page 66
Combining Result Sets with UNION......Page 67
How It Works......Page 68
Using CROSS APPLY......Page 69
How It Works......Page 70
Using OUTER APPLY......Page 71
Using the TABLESAMPLE to Return Random Rows......Page 72
Using PIVOT to Convert Single Column Values into Multiple Columns and Aggregate Data......Page 73
How It Works......Page 75
Normalizing Data with UNPIVOT......Page 76
How It Works......Page 77
Returning Distinct or Matching Rows Using EXCEPT and INTERSECT......Page 78
How It Works......Page 79
Summarizing Data Using CUBE......Page 80
Summarizing Data Using ROLLUP......Page 82
Creating Custom Summaries Using Grouping Sets......Page 83
Revealing Rows Generated by GROUPING......Page 85
How It Works......Page 86
Advanced Group-Level Identification with GROUPING_ID......Page 87
How It Works......Page 89
Using a Non-Recursive Common Table Expression......Page 90
How It Works......Page 92
Using a Recursive Common Table Expression......Page 93
How It Works......Page 94
INSERT......Page 97
How It Works......Page 98
Inserting a Row Using Default Values......Page 99
Explicitly Inserting a Value into an IDENTITY Column......Page 100
Inserting a Row into a Table with a uniqueidentifier Column......Page 101
Inserting Rows Using an INSERT...SELECT Statement......Page 102
How It Works......Page 103
Inserting Data from a Stored Procedure Call......Page 104
Inserting Multiple Rows with VALUES......Page 105
Using VALUES As a Table Source......Page 106
UPDATE......Page 107
How It Works......Page 108
How It Works......Page 109
Updating Large Value Data Type Columns......Page 110
How It Works......Page 111
Inserting or Updating an Image File Using OPENROWSET and BULK......Page 112
How It Works......Page 113
Storing Unstructured Data on the File System While Maintaining SQL Server Transactional Control......Page 114
How It Works......Page 117
Assigning and Modifying Database Values “in Place”......Page 118
Deleting Rows......Page 120
How It Works......Page 121
How It Works......Page 122
Chunking Data Modifications with TOP......Page 123
Executing INSERTs, UPDATEs, and DELETEs in a Single Statement......Page 124
How It Works......Page 126
Returning Rows Affected by a Data Modification Statement......Page 127
How It Works......Page 129
Asynchronously Capturing Table Data Modifications......Page 130
Querying All Changes from CDC Tables......Page 133
How It Works......Page 136
Querying Net Changes from CDC Tables......Page 137
Translating the CDC Update Mask......Page 138
Working with LSN Boundaries......Page 139
How It Works......Page 140
Tracking Net Data Changes with Minimal Disk Overhead......Page 141
How It Works......Page 147
Transaction Control......Page 149
Using Explicit Transactions......Page 151
How It Works......Page 152
Displaying the Oldest Active Transaction with DBCC OPENTRAN......Page 153
Querying Transaction Information by Session......Page 154
Locking......Page 156
Viewing Lock Activity......Page 158
How It Works......Page 159
Controlling a Table’s Lock Escalation Behavior......Page 160
How It Works......Page 161
Transaction, Locking, and Concurrency......Page 162
Configuring a Session’s Transaction Locking Behavior......Page 163
How It Works......Page 166
Identifying and Resolving Blocking Issues......Page 168
Configuring How Long a Statement Will Wait for a Lock to Be Released......Page 170
Deadlocking......Page 171
Identifying Deadlocks with a Trace Flag......Page 172
Setting Deadlock Priority......Page 175
How It Works......Page 176
Table Basics......Page 177
Adding a Column to an Existing Table......Page 181
Changing an Existing Column Definition......Page 182
Creating a Computed Column......Page 183
Reducing Storage for Null Columns......Page 184
Dropping a Table Column......Page 187
Dropping a Table......Page 188
Viewing Collation Metadata......Page 189
Designating a Column’s Collation......Page 190
Keys......Page 191
Creating a Table with a Primary Key......Page 192
How It Works......Page 193
How It Works......Page 194
How It Works......Page 195
How It Works......Page 196
Allowing Cascading Changes in Foreign Keys......Page 197
How It Works......Page 198
Using the IDENTITY Property During Table Creation......Page 199
Using DBCC CHECKIDENT to View and Correct IDENTITY Seed Values......Page 200
How It Works......Page 201
Constraints......Page 202
Creating a Unique Constraint......Page 203
Adding a UNIQUE Constraint to an Existing Table......Page 204
How It Works......Page 205
How It Works......Page 206
Disabling and Enabling a Constraint......Page 207
Using a DEFAULT Constraint During Table Creation......Page 208
How It Works......Page 209
Temporary Tables and Table Variables......Page 210
Using a Temporary Table for Multiple Lookups Within a Batch......Page 211
Creating a Table Variable to Hold a Temporary Result Set......Page 212
How It Works......Page 213
Manageability for Very Large Tables......Page 214
Implementing Table Partitioning......Page 215
How It Works......Page 217
Determining the Location of Data in a Partition......Page 218
How It Works......Page 219
Adding a New Partition......Page 220
How It Works......Page 221
How It Works......Page 222
Moving a Partition to a Different Table......Page 223
Removing Partition Functions and Schemes......Page 224
Easing VLDB Manageability with Filegroups......Page 225
Reducing Disk Space Usage with Data Compression......Page 226
How It Works......Page 229
Index Overview......Page 231
Creating a Table Index......Page 233
Enforcing Uniqueness on Non-Key Columns......Page 235
How It Works......Page 236
Viewing Index Meta Data......Page 237
How It Works......Page 238
How It Works......Page 239
Changing an Existing Index with DROP_EXISTING......Page 240
How It Works......Page 241
Allowing User Table Access During Index Creation......Page 242
Using an Index INCLUDE......Page 243
How It Works......Page 244
How It Works......Page 245
Creating an Index on a Filegroup......Page 246
How It Works......Page 247
How It Works......Page 248
How It Works......Page 249
Creating a Full-Text Catalog......Page 251
How It Works......Page 252
Creating a Full-Text Index......Page 253
How It Works......Page 254
Modifying a Full-Text Catalog......Page 255
Modifying a Full-Text Index......Page 256
How It Works......Page 258
Retrieving Full-Text Catalog and Index Metadata......Page 259
Discarding Common Strings from a Full-Text Index......Page 260
Dropping a Full-Text Index......Page 263
Basic Searching......Page 264
How It Works......Page 265
Advanced Searching......Page 266
Using CONTAINS to Search for Inflectional Matches......Page 267
How It Works......Page 268
Returning Ranked Search Results by Meaning......Page 269
Returning Ranked Search Results by Weighted Value......Page 270
How It Works......Page 271
Views......Page 273
Creating a Basic View......Page 274
Querying the View Definition......Page 276
Displaying Views and Their Structures......Page 277
Refreshing a View’s Definition......Page 278
Dropping a View......Page 279
Modifying Data Through a View......Page 280
How It Works......Page 281
Creating an Indexed View......Page 282
How It Works......P
想了解更多信息?可向上传者提问。点击提问
欢迎您上传文件!
费劲心机找到了自己想要的文件?
不如上传简单麦麦!
分享给别人!还能赚取收益
下载须知
1.如有解压密码 提取码都在下面 注意查看
2.如果有问题 可以通过卖家联系方式 联系卖家 如果没有或无法解决可以联系官方客服
3.本文件为公益分享,文件由网上采集而来,如有侵权等问题,请及时联系客服删除

常见问题及官方客服联系方式:点击前往 售后问题处理方式:点击前往
-到底部了哦-
expand_less