Instant SQL server 2000 applications

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. The Ultimate Collection of Ready-to-Use Code and Expert Techniques Build robust SQL Server 2000 database applications easily using the pre-built projects packed into this essential resource. Inside,you'll find step-by-step details for creating several practical tools that use SQL Server 2000 as the back-end. Every application,script,and code snippet is contained on the CD and is cross-referenced and explained in the text,making it easier to find exactly what you're looking for. Save yourself hundreds of programming hours with this invaluable toolkit. With this book,you'll learn to create the following: Money Manager Personal Information Manager (PIM) Help Desk Network Management Tool Code Library Customer Tracking Application Event Manager Collection Manager Online Store E-books Coverage includes: Triggers Stored Procedures Visual Basic. NET Active Server Pages (ASP) Access T-SQL SQL Server 2000 security features On the value-packed CD-ROM: All of the book's source code Practical sample applications 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 Learn how to create your own SQL Server 2000applications using this book's ten case-study examples. -- Edited summary from book