BN.com Gift Guide

Transact-SQL

( 1 )

Overview

Take complete command of Microsoft SQL Server 7 with the latest version of Transact-SQL query language - from constructing powerful Transact-SQL queries to interacting with SQL tables and records through the DB-Library, the ODBC API, and the new COM-based ActiveX Data Objects (ADO). Learn to use Open Data Services (ODS) to write extended stored procedures. Loaded with sample queries, scripts, extended stored procedures, and triggers you can use right away, Transact-SQL demonstrates all the SQL tools and ...
See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (9) from $1.99   
  • New (1) from $25.59   
  • Used (8) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$25.59
Seller since 2008

Feedback rating:

(172)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
0764580485 BRAND NEW NEVER USED IN STOCK 125,000+ HAPPY CUSTOMERS SHIP EVERY DAY WITH FREE TRACKING NUMBER

Ships from: fallbrook, CA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

Take complete command of Microsoft SQL Server 7 with the latest version of Transact-SQL query language - from constructing powerful Transact-SQL queries to interacting with SQL tables and records through the DB-Library, the ODBC API, and the new COM-based ActiveX Data Objects (ADO). Learn to use Open Data Services (ODS) to write extended stored procedures. Loaded with sample queries, scripts, extended stored procedures, and triggers you can use right away, Transact-SQL demonstrates all the SQL tools and techniques you need to build SQL, Server enterprise database applications.
Read More Show Less

Editorial Reviews

Bill Carmada
With SQL Server 7's increased popularity, many developers are learning its Transact-SQL language for the first time. But even if you've worked with SQL Server before, you'll find plenty that's new. For instance, Transact-SQL now offers full support for Microsoft's powerful OLE DB interface and ADO model, simplifying development of multi-tier applications that require access to diverse relational and non-relational data.

William C. Amo's Transact-SQL is an excellent single source for learning all that Transact-SQL can do-from the absolute basics, all the way to advanced SQL Server features for the enterprise. What's really nice about this book: Amo writes with exceptional clarity. You won't find yourself rereading, scratching your head, and wondering where you misplaced those IQ points.

You'll start by reviewing the SQL Server Programming environment, including SQL Server Tools such as the Enterprise Manager, Query Analyzer, and Client Configuration Utility. Next, you'll review SQL Server's fundamental security mechanisms-critical information you must know before you start writing applications. You'll compare Windows NT Authentication mode and SQL Server Authentication mode and learn how to manage users, logins, roles and permissions.

Once you know your way around, Amo presents the basics of Transact-SQL commands and syntax, in the context of a sample investment database designed to store mutual fund account information for investors. (The database and all the book's sample scripts, queries, stored procedures and triggers are available on CD-ROM.) Along the way, you'll find detailed coverage of SET statements and batching.

Next, Amo introduces the basics of SQL Server Data Definition Language (DDL). You'll learn how to construct a database by defining data types, specifying physical and log files, creating tables, establishing constraints, using rule and default objects and creating indexes. Once you've created a database, of course, the next step is to manipulate it, so Amo introduces the Data Manipulation Language (DML)-INSERT, UPDATE, DELETE, basic SELECT statements, sorting results, creating tables with SELECT INTO and more. Transact-SQL introduces the six categories of functions available to SQL Server 7 programmers; practical techniques for summarizing data into groups and displaying totals; and how to begin leveraging the true power of relational databases through joins, subqueries and unions. You'll learn how to enhance security and data integrity by implementing views-"virtual tables" that create a buffer between the base tables and your users. There's an excellent introduction to using cursors to improve database performance.

If you're a DBA, you'll find a full chapter covering T-SQL elements designed for you. Learn how to handle key database monitoring tasks through Database Consistency Check (DBCC) statements, including checking database page allocations, checking the integrity of database objects, rebuilding indexes and displaying memory usage. Review SQL Server jobs, jobsteps and schedules, as well as the SQL Server Agent tool that runs them. There's also coverage of backup and recovery via T-SQL.

Once you've got all this nailed down, Amo clearly explains the subtleties of stored procedures, extended stored procedures, and triggers-showing how they can speed execution, reduce network traffic and enhance system performance. Master SQL Server transactions-including Autocommit, implicit, and explicit modes and the Microsoft Distributed Traffic Coordinator (MS DTC). Use the SQL Server Profiler to monitor events and tune your database.

Amo sets aside a full section of the book for comprehensive, hands-on coverage of database access via each of Microsoft's APIs: DB-Library, Open Database Connectivity (ODBC), ActiveX Data Objects (ADO) and Open Data Services (ODS) programs. Finally, you'll walk through Microsoft's cool Data Transformation Wizards-a great new point-and-click tool for creating data marts and other data subsets.

Concise, practical and above all crystal clear, Transact-SQL is all you need to master SQL Server 7 programming.

Bill Carmada @ Cyberian Express

Read More Show Less

Product Details

  • ISBN-13: 9780764580482
  • Publisher: Wiley
  • Publication date: 1/28/1998
  • Edition number: 1
  • Pages: 526
  • Product dimensions: 7.10 (w) x 9.00 (h) x 1.32 (d)

Meet the Author

About the Author William C. Amo has been developing databases and database systems for over 20 years. He specializes in client/server system and component development using Windows NT servers hosting Microsoft SQL servers. He is a coauthor of IDG Books Worldwide's Access 97 Secrets??.
Read More Show Less

Table of Contents

Preface
Acknowledgments
Pt. I SQL Server Programming Environment
Ch. 1 Introduction to the SQL Server Programming Environment 3
Ch. 2 Using the SQL Server Tools 27
Ch. 3 Understanding SQL Server Security 55
Pt. II The Transact-SQL Language
Ch. 4 Introduction to Transact-SQL 71
Ch. 5 Using the Data Definition Language 95
Ch. 6 Using the Data Manipulation Language 121
Ch. 7 Exploring Transact-SQL Functions 145
Ch. 8 Grouping and Totaling 175
Ch. 9 Exploring Joins, Subqueries, and Unions 191
Ch. 10 Building and Using Views 213
Ch. 11 Working with Text and Images 223
Ch. 12 Using the CUBE and ROLLUP Operators 231
Ch. 13 Introduction to Cursors 239
Ch. 14 Transact-SQL for Administrators 261
Ch. 15 Working with Stored Procedures and Triggers 285
Ch. 16 Exploring Transactions 319
Ch. 17 Monitoring SQL Server Events 327
Pt. III SQL Server Programming
Ch. 18 DB-Library 341
Ch. 19 Open Database Connectivity 349
Ch. 20 ActiveX Data Objects 357
Ch. 21 Open Data Services 365
Pt. IV Appendixes
App. A: What's on the CD-ROM? 375
App. B The FundAccts Sample Database 383
App. C SQL Server SET Statements 389
App. D Functions 395
App. E Reserved Keywords 413
App. F System Stored Procedures 415
App. G SQL Server Databases and Tables 439
App. H Operators Reference 443
App. I Data Types Reference 447
App. J SQL Server 7.0 Technical Specifications 455
App. K spöconfigure and spödboption Settings 459
App. L Files and File Locations 465
App. M Using the Data Transformation Services Wizards 469
Index 475
End-User License Agreement 500
CD-ROM Installation Instructions 504
Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star

(1)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted August 23, 2000

    Clear guide to using SQL Server

    I read this book twice and I continually refer to it. It is understandable for those new to SQL Server, but one should have some technical inclination. There are many simple examples of the concepts. The coverage is comprehensive enough so the student is able to do the usual tasks. If you are going to use SQL Server, then this book will help you do so. I recommend it highly.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)