The Guru's Guide to Transact-SQL

Front Cover
Addison-Wesley Professional, Feb 23, 2000 - Computers - 592 pages
0 Reviews

Since its introduction over a decade ago, the Microsoft SQL Server query language, Transact-SQL, has become increasingly popular and more powerful. The current version sports such advanced features as OLE Automation support, cross-platform querying facilities, and full-text search management.

This book is the consummate guide to Microsoft Transact-SQL. From data type nuances to complex statistical computations to the bevy of undocumented features in the language, The Guru's Guide to Transact-SQL imparts the knowledge you need to become a virtuoso of the language as quickly as possible.

In this book, you will find the information, explanations, and advice you need to master Transact-SQL and develop the best possible Transact-SQL code. Some 600 code examples not only illustrate important concepts and best practices, but also provide working Transact-SQL code that can be incorporated into your own real-world DBMS applications.

Your journey begins with an introduction explaining language fundamentals such as database and table creation, inserting and updating data, queries, joins, data presentation, and managing transactions. Moving on to more advanced topics, the journey continues with in-depth coverage of:

  • Transact-SQL performance tuning using tools such as Query Analyzer and Performance Monitor
  • Nuances of the various T-SQL data types
  • Complex statistical calculations such as medians, modes, and sliding aggregates
  • Run, sequence, and series identification and interrogation
  • Advanced Data Definition Language (DDL) and Data Management Language (DML) techniques
  • Stored procedure and trigger best practices and coding methods
  • Transaction management
  • Optimal cursor use and caveats to look out for
  • Full-text search
  • Hierarchies and arrays
  • Administrative Transact-SQL
  • OLE Automation
  • More than 100 undocumented commands and language features, including numerous unpublished DBCC command verbs, trace flags, stored procedures, and functions

Comprehensive, written in understandable terms, and full of practical information and examples, The Guru's Guide to Transact-SQL is an indispensable reference for anyone working with this database development language. The accompanying CD-ROM includes the complete set of code examples found in the book as well as a SQL programming environment that will speed the development of your own top-notch Transact-SQL code.

 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

VII
1
VIII
2
IX
3
XI
5
XII
6
XIII
7
XV
8
XVI
9
CCXV
235
CCXVI
238
CCXVII
239
CCXVIII
241
CCXIX
242
CCXX
245
CCXXI
246
CCXXII
248

XVIII
10
XX
11
XXII
13
XXIII
14
XXIV
16
XXV
18
XXVII
19
XXIX
20
XXX
21
XXXII
22
XXXIII
23
XXXIV
24
XXXV
25
XXXVI
26
XXXVII
27
XXXVIII
31
XXXIX
34
XL
35
XLII
36
XLIII
37
XLVI
38
XLVII
46
XLVIII
47
L
48
LI
49
LII
54
LIV
55
LV
57
LVI
58
LVIII
59
LX
60
LXI
63
LXII
65
LXIII
66
LXIV
67
LXV
68
LXVI
73
LXVII
75
LXVIII
77
LXIX
78
LXXI
79
LXXII
81
LXXIII
83
LXXIV
85
LXXV
86
LXXVIII
87
LXXXIII
89
LXXXIV
90
LXXXVIII
91
XCII
92
XCV
93
XCVI
94
C
95
CI
97
CII
98
CIII
99
CIV
100
CVI
101
CVII
102
CVIII
103
CIX
104
CX
105
CXII
106
CXV
107
CXVI
108
CXVII
109
CXVIII
110
CXIX
111
CXX
112
CXXI
113
CXXII
114
CXXIII
116
CXXIV
117
CXXV
118
CXXVII
119
CXXVIII
120
CXXIX
121
CXXX
122
CXXXI
126
CXXXIII
128
CXXXV
131
CXXXVI
133
CXXXVII
134
CXXXVIII
135
CXXXIX
136
CXL
137
CXLII
138
CXLIV
140
CXLVI
141
CXLVIII
145
CXLIX
147
CL
150
CLI
152
CLII
153
CLIII
157
CLV
159
CLVI
161
CLVII
163
CLVIII
164
CLIX
165
CLX
166
CLXII
167
CLXIV
168
CLXV
170
CLXVI
172
CLXVII
173
CLXVIII
174
CLXIX
176
CLXXI
177
CLXXIII
181
CLXXIV
183
CLXXV
184
CLXXVI
185
CLXXVII
186
CLXXVIII
188
CLXXIX
190
CLXXX
193
CLXXXII
194
CLXXXIII
195
CLXXXIV
196
CLXXXV
197
CLXXXVI
198
CLXXXVII
199
CLXXXVIII
201
CLXXXIX
202
CXC
203
CXCII
204
CXCIII
205
CXCIV
206
CXCV
207
CXCVII
208
CXCVIII
209
CXCIX
210
CC
211
CCI
212
CCII
213
CCIII
219
CCIV
220
CCV
221
CCVI
223
CCVII
225
CCIX
226
CCX
228
CCXI
229
CCXII
230
CCXIII
231
CCXIV
234
CCXXIII
249
CCXXIV
250
CCXXV
251
CCXXVI
253
CCXXVII
254
CCXXVIII
255
CCXXIX
256
CCXXX
257
CCXXXI
258
CCXXXII
259
CCXXXIII
261
CCXXXIV
263
CCXXXVI
264
CCXXXVII
267
CCXXXVIII
268
CCXXXIX
269
CCXL
272
CCXLIV
274
CCXLV
276
CCXLVII
277
CCXLVIII
279
CCL
281
CCLI
283
CCLII
284
CCLVII
285
CCLXI
286
CCLXIII
287
CCLXVII
288
CCLXVIII
289
CCLXX
290
CCLXXI
291
CCLXXII
292
CCLXXIII
293
CCLXXV
296
CCLXXVI
297
CCLXXVII
299
CCLXXIX
300
CCLXXX
301
CCLXXXI
303
CCLXXXII
304
CCLXXXIII
305
CCLXXXVII
306
CCLXXXVIII
307
CCLXXXIX
308
CCXC
312
CCXCII
314
CCXCIII
316
CCXCV
317
CCXCVII
320
CCXCVIII
321
CCXCIX
322
CCC
323
CCCIII
324
CCCIV
325
CCCV
328
CCCIX
330
CCCXII
334
CCCXIII
335
CCCXIV
337
CCCXV
338
CCCXVI
340
CCCXVII
342
CCCXVIII
344
CCCXX
346
CCCXXII
347
CCCXXIII
351
CCCXXIV
368
CCCXXV
369
CCCXXVII
370
CCCXXIX
371
CCCXXX
374
CCCXXXI
380
CCCXXXII
384
CCCXXXIII
385
CCCXXXVI
386
CCCXXXVII
387
CCCXXXIX
388
CCCXL
389
CCCXLI
391
CCCXLIV
394
CCCXLV
396
CCCXLVI
397
CCCXLVII
398
CCCXLIX
399
CCCL
401
CCCLI
402
CCCLV
404
CCCLVI
405
CCCLVIII
410
CCCLIX
414
CCCLX
416
CCCLXI
419
CCCLXIII
421
CCCLXIV
427
CCCLXV
432
CCCLXVII
435
CCCLXVIII
437
CCCLXIX
440
CCCLXX
443
CCCLXXI
445
CCCLXXII
448
CCCLXXIII
453
CCCLXXIV
456
CCCLXXV
461
CCCLXXVI
463
CCCLXXVII
468
CCCLXXVIII
469
CCCLXXIX
471
CCCLXXXI
472
CCCLXXXII
474
CCCLXXXIV
475
CCCLXXXV
476
CCCLXXXVI
480
CCCLXXXVII
484
CCCLXXXVIII
486
CCCLXXXIX
487
CCCXC
488
CCCXCIII
489
CCCXCV
490
CCCXCVII
491
CCCXCIX
492
CDI
493
CDVI
494
CDXI
495
CDXIII
496
CDXIV
497
CDXVI
498
CDXVII
499
CDXXII
500
CDXXIV
501
CDXXVI
502
CDXXVIII
503
CDXXIX
509
CDXXX
511
CDXXXI
513
CDXXXII
514
CDXXXIII
515
CDXXXIV
518
CDXXXV
519
CDXXXVI
521
CDXXXVII
524
CDXXXVIII
525
CDXXXIX
526
CDXL
527
CDXLI
528
CDXLII
529
Copyright

Other editions - View all

Common terms and phrases

About the author (2000)

Ken Henderson, a nationally recognized consultant and leading DBMS practitioner, consults on high-end client/server projects for such customers as the U.S. Air Force, the U.S. Navy, H&R Block, Travelers Insurance, J.P. Morgan, the CIA, Owens-Corning, and CNA Insurance. He is the author of five previous books on client/server and DBMS development, a frequent magazine contributor to such publications as Software Development Magazine and DBMS Magazine, and a speaker at technical conferences.

Bibliographic information