Code Centric: T-SQL Programming with Stored Procedures and Triggers
If you want to learn how to write stored procedures and triggers for Microsoft SQL Server, Code Centric: T-SQL Programming with Stored Procedures and Triggers is the book for you. Youll learn real-world coding and how to build non-trivial applications. All of the examples covered in the book are available for download, making it easier to work through over 5,000 lines of sample code.

While there is extensive coverage of the new functionality in SQL Server 2000—such as UDFs (user-defined functions)—you can use this book effectively for virtually any version of SQL Server6.x, 7.0, or 2000.

1100908007
Code Centric: T-SQL Programming with Stored Procedures and Triggers
If you want to learn how to write stored procedures and triggers for Microsoft SQL Server, Code Centric: T-SQL Programming with Stored Procedures and Triggers is the book for you. Youll learn real-world coding and how to build non-trivial applications. All of the examples covered in the book are available for download, making it easier to work through over 5,000 lines of sample code.

While there is extensive coverage of the new functionality in SQL Server 2000—such as UDFs (user-defined functions)—you can use this book effectively for virtually any version of SQL Server6.x, 7.0, or 2000.

59.99 In Stock
Code Centric: T-SQL Programming with Stored Procedures and Triggers

Code Centric: T-SQL Programming with Stored Procedures and Triggers

by Garth Wells
Code Centric: T-SQL Programming with Stored Procedures and Triggers

Code Centric: T-SQL Programming with Stored Procedures and Triggers

by Garth Wells

Overview

If you want to learn how to write stored procedures and triggers for Microsoft SQL Server, Code Centric: T-SQL Programming with Stored Procedures and Triggers is the book for you. Youll learn real-world coding and how to build non-trivial applications. All of the examples covered in the book are available for download, making it easier to work through over 5,000 lines of sample code.

While there is extensive coverage of the new functionality in SQL Server 2000—such as UDFs (user-defined functions)—you can use this book effectively for virtually any version of SQL Server6.x, 7.0, or 2000.

Product Details

ISBN-13: 9781893115835
Publisher: Apress
Publication date: 01/30/2001
Edition description: First Edition
Pages: 695
Product dimensions: 7.52(w) x 9.25(h) x 0.06(d)

About the Author

Garth Wells is president of DataDrivenWebSites.com, Inc., a company that focuses on web-enabling SQL Server databases. He has designed and implemented database solutions for over seven years, and has successfully implemented database solutions in a number of different industries including computer design, medical informatics, and commercial real estate management. Garth has written for Pinnacle Publishing's newsletter SQL Server Professional and he is the co-author of 10 Projects You Can Do with Microsoft SQL Server 7.

Table of Contents

1 Transact-SQL Overview.- 2 Data Types.- 3 Data Definition Language.- 4 DML: SELECT, JOINs, and Control-of-Flow.- 5 DML: Inserting, Updating, and Deleting Data.- 6 Built-In Functions.- 7 User-Defined Functions.- 8 Views.- 9 System Stored Procedures.- 10 Extended Stored Procedures.- 11 User-Defined Stored Procedures.- 12 Triggers.- 13 Procedures and Triggers by Example.- 14 Building an Application.- Appendix A HTML Primer.- Before You Get Started.- Accessing Web Sites.- Maintaining a Hosted Web Site.- HTML Tags.- Tag Fundamentals.- Tag Descriptions.- Tag Attributes.- Creating HTML Pages.- HTML by Example.- Example 1.- Example 2.- Example 3.- Example 4.- Additional Resources.- Before You Go.- Appendix B ASP Primer.- Before You Get Started.- ASP Primer.- ASP Basics.- Working with Databases.- Pulling It All Together.- Additional Internet Resources.- Before You Go.- Appendix C Query Optimization and Application Performance Primer.- Before You Get Started.- Over-Indexing a Database.- The Ramifications of Client-Side Code.- Query Optimization.- Query Optimizer, Indexes, and Search Arguments (SARGs).- Query Optimization Tools in Query Analyzer.- Index Tuning Wizard.- Analyzing a Database.- Analyzing a Query.- Application Design Issues.- Database Design.- Denormalization.- Server-Side Processing.- Indexing Strategy.- Test Throughout the Development Cycle.- Before You Go.- Appendix D XML Primer.- Before You Get Started.- The Origin of XML.- XML Basics.- SQL/XML Primer.- Configuring SQL/XML Support.- Accessing Data via HTTP.- SELECT... FOR XML.- FOR XML Examples.- OPENXML.- Updategrams.- Integrating ASP and XML.- Update Example.- Additional Internet Resources.- Before You Go.
From the B&N Reads Blog
Page 1 of

Related Subjects

Computers
Computer Programming
Database Management
Software Engineering
Applications & Languages - Databases
General Software Engineering
SQL
Software Development * Programming
T-SQL/Transact-SQL
Computers
Computer Programming
Database Management
Software Engineering
Applications & Languages - Databases
General Software Engineering
SQL
Software Development * Programming
T-SQL/Transact-SQL

Customer Reviews