Guru's Guide to Transact-SQL, The
Language: English
Published by Addison-Wesley Professional, 2000
- Softcover
- Used
Seller: Hopkins Books, Nashua, NH, U.S.A.Hopkins Books
AbeBooks seller since May 19, 2021
Condition: Used - Near fine
£ 23.14
Quantity: 1 available
Add to basketItem description from seller
Softcover edition, published by Addison-Wesley, 2000. this copy is a 6th printing, published September 2002. Guide to Microsoft Transact-SQL, with 600 code examples. 552 pages, 7-1/2" x 9". Includes the DVD, though the envelope has been opened and the DVD has been used. No writing on the text pages, no former ownership marks. Edges of the text block are clean. Not a remainder, not a library discard copy. Attached photo is of the copy we have in our inventory.
Seller Inventory # 24-02067
- Title
- Guru's Guide to Transact-SQL, The
- Author
- Ken Henderson
- Publisher
- Addison-Wesley Professional
- Publication year
- 2000
- Condition
- Near Fine
- Binding
- Soft cover
- Language
- English
- ISBN 10
- 0201615762
- ISBN 13
- 9780201615760
- Seller catalogs
- Computer Science, Math, Science
Since its introduction over a decade ago, the Microsoft SQL Server query language, Transact-SQL, has become increasingly popular and more powerful. The current version sports such advanced features as OLE Automation support, cross-platform querying facilities, and full-text search management.
This book is the consummate guide to Microsoft Transact-SQL. From data type nuances to complex statistical computations to the bevy of undocumented features in the language, The Guru's Guide to Transact-SQL imparts the knowledge you need to become a virtuoso of the language as quickly as possible.
In this book, you will find the information, explanations, and advice you need to master Transact-SQL and develop the best possible Transact-SQL code. Some 600 code examples not only illustrate important concepts and best practices, but also provide working Transact-SQL code that can be incorporated into your own real-world DBMS applications.
Your journey begins with an introduction explaining language fundamentals such as database and table creation, inserting and updating data, queries, joins, data presentation, and managing transactions. Moving on to more advanced topics, the journey continues with in-depth coverage of:
- Transact-SQL performance tuning using tools such as Query Analyzer and Performance Monitor
- Nuances of the various T-SQL data types
- Complex statistical calculations such as medians, modes, and sliding aggregates
- Run, sequence, and series identification and interrogation
- Advanced Data Definition Language (DDL) and Data Management Language (DML) techniques
- Stored procedure and trigger best practices and coding methods
- Transaction management
- Optimal cursor use and caveats to look out for
- Full-text search
- Hierarchies and arrays
- Administrative Transact-SQL
- OLE Automation
- More than 100 undocumented commands and language features, including numerous unpublished DBCC command verbs, trace flags, stored procedures, and functions
Comprehensive, written in understandable terms, and full of practical information and examples, The Guru's Guide to Transact-SQL is an indispensable reference for anyone working with this database development language. The accompanying CD-ROM includes the complete set of code examples found in the book as well as a SQL programming environment that will speed the development of your own top-notch Transact-SQL code.
"Synopsis" may belong to another edition of this title.
About the Author
Ken Henderson, a nationally recognized consultant and leading DBMS practitioner, consults on high-end client/server projects for such customers as the U.S. Air Force, the U.S. Navy, H&R Block, Travelers Insurance, J.P. Morgan, the CIA, Owens-Corning, and CNA Insurance. He is the author of five previous books on client/server and DBMS development, a frequent magazine contributor to such publications as Software Development Magazine and DBMS Magazine, and a speaker at technical conferences.
0201615762AB07032003
"About the title" may belong to another edition of this title.
Shipping rates within U.S.A.
| Item | 7 to 14 business days | 3 to 6 business days |
|---|---|---|
| First item | £ 5.06 | £ 18.54 |
Payment methods
Store description
Hopkins Books specializes in 20th Century genre fiction, Art History, and classic literary Fiction.
Specialty
and classic literary fiction, Military History, Art History, History, genre fictionSeller's business information
Hopkins Books
NH, U.S.A.
We're a small, independent, family run book seller specializing in current fiction and non-fiction, with an emphasis on Art, Art History, History, Memoirs, Travel Memoirs, Signed First Editions, and Literature in Translation.
Do you have any questions about our books ? Let us know, we'd love to hear from you!
Do you want to see a photo of a book before you order it ? We try to post as many photos as possible, but sometimes there will be a item in inventory that does not show a photo here. So feel free to ask for photos, we don't mind at all.
We package all of our orders carefully either in a box that has been designed to ship books, or in a padded envelope. We want to make sure you receive your order in the best possible condition!
Our preferred shipping method is USPS Media Mail. Recently, the USPS has added tracking to Media Mail , which has been a great addition to this service.
If you do choose to have your order shipped "Expedited", my shipping cost may seem higher than expected. Some of our books are large format hardcovers that can cost quite a bit when shipped expedited. So I would like to make sure that I can cover the cost upfront. However, if the actual cost of expedited shipping is less than the charge, I will refund the difference!
Right of withdrawal
If you are a consumer you can withdraw from the contract in accordance with the following. Consumer means any natural person who is acting for purposes which are outside his trade, business, craft or profession.
Information regarding the right of withdrawal
Statutory right to withdraw
You have the right to withdraw from this contract within 14 days without giving any reason.
The withdrawal period will expire after 14 days from the day on which you acquire, or a third party other than the carrier and indicated by you acquires, physical possession of the last good or the last lot or piece.
To exercise the right of withdrawal, electronically fill in and submit a clear statement on our website, under "My Purchases" in "My Account". We will communicate to you an acknowledgement of receipt of such a withdrawal on a durable medium (e.g. by e-mail) without delay.
To meet the withdrawal deadline, it is sufficient for you to send your communication concerning your exercise of the right of withdrawal before the withdrawal period has expired.
Effects of withdrawal
If you withdraw from this contract, we will reimburse to you all payments received from you, including the costs of delivery (except for the supplementary costs arising if you chose a type of delivery other than the least expensive type of standard delivery offered by us).
We may make a deduction from the reimbursement for loss in value of any goods supplied, if the loss is the result of unnecessary handling by you.
We will make the reimbursement without undue delay, and not later than 14 days after the day on which we are informed about your decision to withdraw from this contract.
We will make the reimbursement using the same means of payment as you used for the initial transaction, unless you have expressly agreed otherwise; in any event, you will not incur any fees as a result of such reimbursement.
We may withhold reimbursement until we have received the goods back, or you have supplied evidence of having sent back the goods, whichever is the earliest.
You shall send back the goods or hand them over to Hopkins Books, Nashua, New Hampshire, U.S.A., without undue delay and in any event not later than 14 days from the day on which you communicate your withdrawal from this contract to us. The deadline is met if you send back the goods before the period of 14 days has expired. You will have to bear the direct cost of returning the goods. You are only liable for any diminished value of the goods resulting from the handling other than what is necessary to establish the nature, characteristics and functioning of the goods.
Exceptions to the right of withdrawal
The right of withdrawal does not apply to:
- The delivery of newspapers, journals or magazines with the exception of subscription contracts; and
- The supply of digital content which is not supplied on a tangible medium (e.g. on a CD or DVD) if you accepted when you placed your order that we could start to deliver it, and that you could not withdraw once delivery had started.