All Categories /
Computers & Technology /
Programming

Transact-SQL Programming: Covers Microsoft SQL Server 6.5 /7.0 and Sybase Adaptive Server 11.5

(11)
Transact-SQL Programming: Covers Microsoft SQL Server 6.5 /7.0 and Sybase Adaptive Server 11.5 image
ISBN-10:

1565924010

ISBN-13:

9781565924017

Author(s): Kline, Kevin; Gould, Lee
Edition: 1
Released: May 11, 1999
Publisher: O'Reilly Media
Format: Paperback, 836 pages
Find in Library

Description:

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.

Best prices to buy, sell, or rent ISBN 9781565924017

‌
‌
‌

Frequently Asked Questions about Transact-SQL Programming: Covers Microsoft SQL Server 6.5 /7.0 and Sybase Adaptive Server 11.5

You can buy the Transact-SQL Programming: Covers Microsoft SQL Server 6.5 /7.0 and Sybase Adaptive Server 11.5 book at one of 20+ online bookstores with BookScouter, the website that helps find the best deal across the web. Currently, the best offer comes from ‌ and is $‌ for the ‌.

The price for the book starts from $6.60 on Amazon and is available from 27 sellers at the moment.

If you’re interested in selling back the Transact-SQL Programming: Covers Microsoft SQL Server 6.5 /7.0 and Sybase Adaptive Server 11.5 book, you can always look up BookScouter for the best deal. BookScouter checks 30+ buyback vendors with a single search and gives you actual information on buyback pricing instantly.

As for the Transact-SQL Programming: Covers Microsoft SQL Server 6.5 /7.0 and Sybase Adaptive Server 11.5 book, the best buyback offer comes from ‌ and is $‌ for the book in good condition.‌

‌‌‌‌‌‌‌‌‌‌

The Transact-SQL Programming: Covers Microsoft SQL Server 6.5 /7.0 and Sybase Adaptive Server 11.5 book is in very low demand now as the rank for the book is 2,595,652 at the moment. A rank of 1,000,000 means the last copy sold approximately a month ago.

Not enough insights yet.