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

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

byGarth Wells

Hardcover | January 30, 2001

Pricing and Purchase Info

$60.78 online 
$110.50 list price save 44%
Earn 304 plum® points

Prices and offers may vary in store

Quantity:

In stock online

Ships free on orders over $25

Not available in stores

about

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 Triggersis 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.

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 comme...
Loading
Title:Code Centric: T-SQL Programming with Stored Procedures and TriggersFormat:HardcoverDimensions:695 pagesPublished:January 30, 2001Publisher:APRESS PUBLISHERSLanguage:English

The following ISBNs are associated with this title:

ISBN - 10:1893115836

ISBN - 13:9781893115835

Look for similar items by category:

Reviews

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.