Name: Code Centric: T-SQL Programming with Stored Procedures and Triggers By Garth Wells
SKU: 9781893115835
Price: 6.60 GBP
Availability: InStock

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

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

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.

About Garth Wells

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.

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.

Additional information

Sku

GOR002875072

ISBN 13

9781893115835

ISBN 10

1893115836

Title

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

Author

Garth Wells

Condition

Used - Very Good

Binding type

Paperback

Publisher

APress

Year published

20010130

Number of pages

695

Prizes

N/A

Cover note

Book picture is for illustrative purposes only, actual binding, cover or edition may vary.

Note

This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us

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

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

Summary

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

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

About Garth Wells

Table of Contents

Additional information

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