Transact-SQL Programming
Covers Microsoft SQL Server 6.5 /7.0 and Sybase Adaptive Server 11.5
Publisher: O'Reilly Media
Final Release Date: April 1999
Pages: 840

Transact-SQL is a procedural language used on both Microsoft SQL Server and Sybase SQL Server systems. It is a full-featured programming language that dramatically extends the power of SQL (Structured Query Language).The language provides programmers with a broad range of features, including:

  • A rich set of datatypes, including specialized types for identifiers, timestamps, images, and long text fields
  • Local and global variables
  • Fully programmable server objects like views, triggers, stored procedures, and batch command files
  • Conditional processing
  • Exception and error handling
  • Full transaction control
  • System stored procedures that reduce the complexity of many operations, like adding users or automatically generating HTML Web pages
In recent years, the versions of Transact-SQL have diverged on Microsoft and Sybase systems; the book explains the differences. It also contains up-to-the-minute information on the latest versions: Microsoft SQL Server versions 6.5 and 7.0 and Sybase version 11.5.A brief table of contents follows:PART I: The Basics: Programming in Transact-SQL1. Introduction to Transact-SQL2. Matching Business Rules3. SQL Primer4. Transact-SQL Fundamentals5. Format and StylePART II: The Building Blocks: Transact-SQL Language Elements6. Datatypes and Variables7. Conditional Processing8. Row Processing with Cursors9. Error Handling10. Temporary Objects11. Transactions and LoggingPART III: Functions and Extensions12. Functions13. CASE Expressions and Transact-SQL ExtensionsPART IV: Programming Transact-SQL Objects14. Stored Procedures and Modular Design15. Triggers16. Views17. System and Extended Stored Procedures and BCPPART V: Performance Tuning and Optimization18. Transact-SQL Code Design19. Code Maintenance in the SQL Server20. Transact-SQL Optimization and Tuning21. Debugging Transact-SQL ProgramsPART VI: AppendixesA. System TablesB. What's New for Transact-SQL in Microsoft SQL Server 7.0? C. BCPThe book comes with a CD-ROM containing an extensive set of examples from the book and complete programs that illustrate the power of the language.
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyTransact-SQL Programming
 
2.7

(based on 3 reviews)

Ratings Distribution

  • 5 Stars

     

    (1)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (1)

  • 1 Stars

     

    (1)

Reviewed by 3 customers

Sort by

Displaying reviews 1-3

Back to top

(1 of 2 customers found this review helpful)

 
2.0

Transact-SQL Programming Review

By rohan Pitiya

from Undisclosed

Comments about oreilly Transact-SQL Programming:

REgarding the article publish in sqlservercentrl on t-sql performance tunining Part -2 which is an extract from this book....

1.It says on p12, by adding anotther constraint( p.productid = s.productid) in the where clause you get a perfomace boost. If SQL server doesn't know A=c when A=B and B=C, then sql has to check this which means an added overhead(redundant) to the the query. In my experiecnce I have removed lot of this type redunant filterations which boosted performance(opposite to the argument)

2. When using OR replacing with UNION queries..

this again if you have or statements in one query, when sql evaluates from left to right, the first neagative condition will end the checking. But as you indicate, irrespective of results, sql has to evaluvate for all coditions in the OR clause.

(1 of 2 customers found this review helpful)

 
1.0

Transact-SQL Programming Review

By Matt

from Undisclosed

Comments about oreilly Transact-SQL Programming:

This book is now extrememly out of date. The datatypes are not even up to date with SQL Server 2000. You need a new version of this book that is up to date. $50 is also way to much for a book that is now two versions behind (because this doesn't even cover version 7.0 completely). I have come to expect better from O'Reilly...

(2 of 2 customers found this review helpful)

 
5.0

Transact-SQL Programming Review

By Mike T.

from Undisclosed

Comments about oreilly Transact-SQL Programming:

Down-to-earth and practical manual. It is comparable with

'PL/SQL Oracle programming' book that Oreilly sells in

its scope, accuracy, and depth of coverage.

I recommend this book for anyone with experience in procedural

SQL-based languages new to Transact-SQL environment. The

presentation is layed out logically and in well-paced units.

Some humor is sprinkled at the right frequency to keep material

from becoming desert-dry.

------------

Mike

Displaying reviews 1-3

Back to top

 
Free Shipping Guarantee
Buying Options
This product has been canceled.