Transact-SQL

Name: Transact-SQL
Price: 7.14 USD
Availability: InStock
ISBN: 9780672310454

ISBN-10: 0672310457

ISBN-13: 9780672310454

Edition: 1997

Authors: Bennett W. McEwan, David Solomon

List price: $35.00

30 day, 100% satisfaction guarantee!

Marketplace

2 new & used from $7.14

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

Showing everyone from the novice programmer to the advanced programmer methods for improved productivity without a reduction in performance, this book gives coding standards to improve productivity, techniques to solve complex problems, templates of procedures, and more.

Book details

List price: $35.00
Copyright year: 1997
Publisher: Sams
Binding: Paperback
Pages: 595
Size: 8.00" wide x 9.00" long x 1.25" tall
Weight: 2.244
Language: English



Introduction



Introduction to Transact-SQL



Retrieving Data



Selecting Rows with the WHERE Clause



All About Columns



Aggregates



Totals and Subtotals



Joining Tables



Subqueries



INSERT, UPDATE, and DELETE



Temporary Tables and Views



Databases, Object Naming, and Batches



Batch Programming Structures



Transactions



Cursors



How the Server Uses Indexes



Stored Procedures



Procedures and Performance



Advanced Stored Procedure Issues



Triggers



Advanced Topics: Single-Table Queries



Advanced Topics: Joins and Subqueries


Answers to Quizzes and Exercises


Index