Skip to main content
PBS logo
 
 

Search - Transact-SQL Programming

Transact-SQL Programming
TransactSQL Programming
Author: Lee Gould, Andrew Zanevsky, Kevin Kline
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 specializ...  more »
  • 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-SQL 2. Matching Business Rules 3. SQL Primer 4. Transact-SQL Fundamentals 5. Format and StylePART II: The Building Blocks: Transact-SQL Language Elements6. Datatypes and Variables 7. Conditional Processing 8. Row Processing with Cursors 9. Error Handling 10. Temporary Objects 11. Transactions and LoggingPART III: Functions and Extensions12. Functions 13. CASE Expressions and Transact-SQL ExtensionsPART IV: Programming Transact-SQL Objects14. Stored Procedures and Modular Design 15. Triggers 16. Views 17. System and Extended Stored Procedures and BCPPART V: Performance Tuning and Optimization18. Transact-SQL Code Design 19. Code Maintenance in the SQL Server 20. Transact-SQL Optimization and Tuning 21. Debugging Transact-SQL ProgramsPART VI: AppendixesA. System Tables B. 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.
ISBN-13: 9781565924017
ISBN-10: 1565924010
Publication Date: 4/1/1999
Pages: 840
Rating:
  ?
0 stars, based on 0 rating
Publisher: O'Reilly
Book Type: Paperback
Members Wishing: 0
Reviews: Amazon | Write a Review


Genres:


Back to the Top ↑
By using this Web site, you confirm that you have read, understood, and agreed to be bound by the Terms of Use. As an Amazon Associate we earn from qualifying purchases.
US Patent Number 7,877,315 | Copyright © 2004 - 2024 PaperBackSwap.com. All Rights Reserved.