Improve functionality and develop robust SQL Server applications with confidence using this collection of pre-written solutions. Best-selling programming author Greg Buczek brings you the most authoritative and useful collection of expert techniques and ready-to-use applications available.
Author(s): Greg Buczek
Publisher: Osborne/McGraw-Hill
Year: 2001
Language: English
Pages: 518
City: Berkeley, CA
Cover......Page 1
Table of Contents......Page 4
Creating a SQL Server Database......Page 5
Creating a Table with the Enterprise Manager......Page 6
Data Types......Page 9
Database Diagrams and Relationships......Page 10
Allowing Users to Access Your Database......Page 11
Views......Page 13
Stored Procedures......Page 15
Triggers......Page 20
Visual Basic 6.0 Data View Window......Page 23
Visual Basic. Net Server Explorer......Page 25
Referencing ADO from Visual Basic 6.0......Page 27
Referencing ADO from Visual Basic. Net......Page 28
Application Walk- Through......Page 29
Stored Procedures......Page 31
Modules......Page 36
Forms......Page 37
Application Walk- Through......Page 52
Tables and Relationships......Page 54
Stored Procedures......Page 55
Using a Data Environment......Page 63
Modules......Page 65
Forms......Page 66
Application Walk- Through......Page 75
Tables and Relationships......Page 77
Stored Procedures......Page 78
Application Notes......Page 88
Modules......Page 89
Application Walk- Through......Page 104
Tables and Relationships......Page 107
Field Specifications......Page 108
Stored Procedures......Page 109
Views......Page 120
Forms......Page 121
Application Walk- Through......Page 135
Field Specifications......Page 137
Stored Procedures......Page 138
Triggers......Page 144
Forms......Page 145
Upsizing to SQL Server......Page 154
Linking Tables......Page 156
Referencing ADO......Page 159
Solution Walk- Through......Page 160
Field Specifications......Page 165
User- Defined Function......Page 167
Stored Procedures......Page 168
Views......Page 186
Roles......Page 187
Modules......Page 188
Solution Walk- Through......Page 203
Tables and Relationships......Page 205
Field Specifications......Page 206
User- Defined Functions......Page 207
Stored Procedures......Page 209
Application Notes......Page 225
Modules......Page 226
Forms......Page 227
Application Walk- Through......Page 239
Fields Specifications......Page 241
User- Defined Functions......Page 242
Stored Procedures......Page 243
Views......Page 259
Modules......Page 260
Forms......Page 261
Application Walk- Through......Page 276
Fields Specifications......Page 278
Triggers......Page 279
User- Defined Functions......Page 281
Stored Procedures......Page 282
Modules......Page 293
Forms......Page 294
Application Walk- Through......Page 306
Field Specifications......Page 308
User- Defined Functions......Page 309
Stored Procedures......Page 310
Application Notes......Page 325
Forms......Page 326
Advantages and Disadvantages of Using ASP......Page 341
Application Issues......Page 342
Web Site Walk- Through......Page 348
Tables and Relationships......Page 351
Field Specifications......Page 352
Triggers......Page 354
Stored Procedures......Page 355
Active Server Pages......Page 368
Web Site Walk- Through......Page 375
Field Specifications......Page 379
Stored Procedures......Page 382
Active Server Pages......Page 394
Web Site Walk- Through......Page 405
Field Specifications......Page 408
Stored Procedures......Page 409
Global. asa File......Page 411
Active Server Pages......Page 412
Web Site Walk- Through......Page 417
Triggers......Page 419
Stored Procedures......Page 421
Active Server Pages......Page 427
Web Site Walk- Through......Page 431
Field Specifications......Page 432
Stored Procedures......Page 433
Active Server Pages......Page 435
Web Site Walk- Through......Page 438
Field Specifications......Page 440
Stored Procedures......Page 441
Active Server Pages......Page 448
Web Site Walk- Through......Page 451
Stored Procedures......Page 453
Active Server Pages......Page 457
Web Site Walk- Through......Page 460
Field Specifications......Page 461
Stored Procedures......Page 462
Active Server Pages......Page 465
Web Site Walk- Through......Page 468
Field Specifications......Page 472
Stored Procedures......Page 473
Active Server Pages......Page 481
E- Help Tool......Page 486
Web Site Walk- Through......Page 487
Field Specifications......Page 488
Stored Procedures......Page 489
Active Server Pages......Page 492
Overview......Page 496
Appendix A: Visual Basic and Visual Basic.NET Quick Reference......Page 0
T- SQL Basics......Page 511