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

The description below is the publishers own description.

Title: Code Centric: T-SQL Programming with Stored Procedures and Triggers ISBN: 1893115836 Pub Date: February 2001 Pages: 692

Overview

Garth Wells teaches readers how to solve everyday programming problems they will face when working with Transact-SQL.

Beginning with a T-SQL overview, Garth addresses data types, data definition language, and built-in functions among other topics. He moves on to provide in-depth coverage of system stored procedures, extended stored procedures, and user-defined stored procedures. In the book's final section, he offers numerous practical code examples based on his own experiences that show readers the variety of tasks that can be automated with Transact-SQL.

• Loaded with real-world code examples that readers can use immediately
• Addresses T-SQL basics with special emphasis on stored procedures and triggers
• Covers the major components of Microsoft SQL Server's T-SQL

Table of Contents

Part I: Transact-SQL Basics Pages

Chapter 1 - T-SQL Overview
Chapter 2 - Data Types
Chapter 3 - Data Definition Language
Chapter 4 - DML: SELECT, JOINs, and Control-of-Flow
Chapter 5 - DML: Inserting, Updating, and Deleting Data
Chapter 6 - Built-In Functions
Chapter 7 - User-Defined Functions
Chapter 8 - Views 

Part II: Procedures and Triggers

Chapter 9 - System Stored Procedures
Chapter 10 - Extended Stored Procedures
Chapter 11 - User-Defined Stored Procedures
Chapter 12 - Triggers

Part III: Putting SQL to Work

Chapter 13 - Procedures and Triggers by Example
Chapter 14 - Building an Application

Appendixes

Appendix A - HTML Primer
Appendix B - ASP Primer
Appendix C - Query Optimization and Application Performance Primer
Appendix D - XML Primer

Sample Chapters

Examples

Buy this book at Amazon

Jump to: Top of Page or HOME or Printer friendly page

Search W3Schools:

What Others Say About Us

Does the world know about us? Check out these places:

Dogpile Alta Vista MSN Google Excite Lycos Yahoo Ask Jeeves

We Help You For Free. You Can Help Us!

• Tell your newsgroup or mailing list
• Link to us from your pages
• Help us correct errors and broken links
• Help us with spelling and grammar
• Validate the XHTML code of this page

W3Schools is for training only. We do not warrant its correctness or its fitness for use. The risk of using it remains entirely with the user. While using this site, you agree to have read and accepted our terms of use and privacy policy.

Copyright 1999-2002 by Refsnes Data. All Rights Reserved

How we converted to XHTML