Back to home page
|Listed in category:

Picture 1 of 1

Advanced Transact-SQL for SQL Server 2000 by Ben-Gan, Itzik; Moreau, Tom - Picture 1 of 1
Have one to sell?
Sell it yourself

Advanced Transact-SQL for SQL Server 2000 by Ben-Gan, Itzik; Moreau, Tom

by Ben-Gan, Itzik; Moreau, Tom | PB | Good
ThriftBooks
(3933338)
Registered as a business seller
Seller's other items
Contact seller
US $16.04
Approximately£11.85
Condition:
Good
“Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, ”... Read moreAbout condition
2 available
Breathe easy. Free postage and returns.
Postage:
Free Economy Shipping.
Estimated between Sat, 26 Jul and Wed, 30 Jul to 94104
Estimated delivery dates - opens in a new window or tab reflect seller's dispatch time, origin postcode, destination postcode and time of order receipt, and will depend on the delivery service selected and receipt of cleared paymentcleared payment - opens in a new window or tab. Delivery times may vary, especially during peak periods, and are an estimate only.
Located in: Aurora, Illinois, United States
Returns:
30 days return. Seller pays for return postage.
Payments:
    Diners Club

Shop with confidence

eBay Money Back Guarantee
Get the item you ordered or your money back. Learn moreeBay Money Back Guarantee - opens new window or tab
Seller assumes all responsibility for this listing.
eBay item number:146358943668
Last updated on 23 Jul, 2025 08:44:36 BSTView all revisionsView all revisions

Item specifics

Condition
Good
A book that has been read, but is in good condition. Minimal damage to the book cover eg. scuff marks, but no holes or tears. If this is a hard cover, the dust jacket may be missing. Binding has minimal wear. The majority of pages are undamaged with some creasing or tearing, and pencil underlining of text, but this is minimal. No highlighting of text, no writing in the margins, and no missing pages. See the seller’s listing for full details and description of any imperfections. See all condition definitionsopens in a new window or tab
Seller notes
“Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, ...
Binding
Paperback
Book Title
Advanced Transact-SQL for SQL Server 2000
Weight
3 lbs
Product Group
Book
IsTextBook
No
ISBN
9781893115828

About this product

Product Identifiers

Publisher
Apress L. P.
ISBN-10
1893115828
ISBN-13
9781893115828
eBay Product ID (ePID)
1875602

Product Key Features

Number of Pages
Xlii, 864 Pages
Publication Name
Advanced TransAct-Sql for Sql Server 2000
Language
English
Publication Year
2000
Subject
Software Development & Engineering / General, Programming Languages / Sql, Databases / General
Features
New Edition
Type
Textbook
Author
Itzik Ben-Gan, Tom Moreau
Subject Area
Computers
Format
Trade Paperback

Dimensions

Item Weight
56.2 Oz
Item Length
9.3 in
Item Width
7.5 in

Additional Product Features

Intended Audience
Scholarly & Professional
Number of Volumes
1 vol.
Illustrated
Yes
Table Of Content
1 Joins in T-SQL.- 2 Subqueries and Derived Tables.- 3 Populating Tables.- 4 Other Data Manipulation Issues.- 5 Summarizing Data.- 6 Special Datatypes and Properties.- 7 Writing Code in Transact-SQL.- 8 Views.- 9 Stored Procedures.- 10 Triggers--the Hidden Stored Procedures.- 11 User-Defined Functions.- 12 Temporary Tables.- 13 Horizontally Partitioned Views.- 14 Implementing Referential Integrity and Cascading Actions.- 15 Server-Side Cursors--the SQL of Last Resort.- 16 Expanding Hierarchies.- 17 Tips and Tricks.- SQL Puzzle Solutions.- Appendix A DML Basics.- Using the SELECT Statement.- The SELECT Clause.- The INTO Clause.- The FROM Clause.- The WHERE Clause.- The GROUP BY Clause.- The HAVING Clause.- The ORDER BY Clause.- Using the INSERT Statement.- The INSERT Clause.- The Column List.- The VALUES Clause.- The Derived Table Clause.- The Execute Clause.- The DEFAULT VALUES Clause.- Using the UPDATE Statement.- The UPDATE Clause.- The SET Clause.- The FROM Clause.- The WHERE Clause.- Using the DELETE Statement.- The DELETE Clause.- The FROM Clause.- The WHERE Clause.- Appendix B Checking for ANSI Compatibility with SET FIPS_FLAGGER.- Appendix C Analyzing Query Performance.- Tools.- System Monitor (Performance Monitor).- Profiler.- SQL Enterprise Manager.- Query Analyzer.- DBCC.- System Stored Procedures.- SET Options.- Methodology.- Is It a SQL Server Problem?.- Which Query Is Slow?.- Is the Query Blocked or Deadlocked?.- What Objects Does the Query Use?.- Are All Objects Actually Being Used?.- How Does the Optimizer Access the Objects?.- How Much Data Is Being Accessed?.- Will an Index Help or Hinder?.- Are Loops and Cursors Necessary?.- Volume and Load Testing.- Appendix D Ownership Chains.- Granting Permissions.- Guidelines for Granting Permissions.- Ownershipof Objects in the Chain.- Use of Statements in Stored Procedures.- Dynamic Execution.- Object References.- Appendix E Pubs and Northwind Database Schemas.- Appendix F Dynamically Creating Triggers for Cascade Actions.- Creating a Delete Cascade Trigger on the Primary (Referenced) Table.- Creating a Prevent Delete Trigger on the Primary (Referenced) Table.- Creating an Update Cascade Trigger on the Primary (Referenced) Table.- Creating a Prevent Update Trigger on the Primary (Referenced) Table.- Creating a Prevent Insert or Update Trigger on the Secondary (Referencing) Table.- Encapsulating the Logic.- Testing the sp_CreateRelationship Stored Procedure.- Appendix G References.- Articles.- SQL Server Magazine (http://www.sglmag.com).- SQL Server Professional (http://www.pinnaclepublishing.com/SQ).- White Papers.- Books.
Edition Description
New Edition
Synopsis
Both authors regularly write articles for the two most important magazines in the SQL Server market: SQL Server Magazine and Microsoft SQL Server Professional. The authors paid special attention to practical needs and problems raised in SQL Server programming newsgroups. Numerous examples are provided throughtout each chapter. Puzzles are presented through the book to encourage the reader to apply skills learned to difficult problems., In this title, the authors pay special attention to practical needs and problems raised in SQL Server programming newsgroups. Numerous examples are provided throughout each chapter. Puzzles are presented through the book to encourage the reader to apply skills learned to difficult problems., In Advanced Transact-SQL for SQL Server 2000 , authors Itzik Ben-Gan and Thomas Moreau explore the powerful capabilities of Transact-SQL (T-SQL). Ben-Gan and Moreau offer solutions to common problems encountered using all versions of SQL Server, with a focus on the latest version, SQL Server 2000. Expert tips and real code examples teach advanced database programmers to write more efficient and better-performing code that takes full advantage of T-SQL. The authors offer practical solutions to the everyday problems programmers face and include in-depth information on advanced T-SQL topics such as joins, subqueries, stored procedures, triggers, user-defined functions (UDFs), indexed views, cascading actions, federated views, hierarchical structures, cursors, and more.
LC Classification Number
QA76.9.D3

Item description from the seller

Seller business information

I certify that all my selling activities will comply with all EU laws and regulations.
About this seller

ThriftBooks

98.9% positive Feedback•19.7M items sold

Joined Mar 2015
Registered as a business seller
Just Voted on Newsweek - ThriftBooks ranks #1 America's Best Online Shops 2025 in Office, Electronics & Media sector, Media category!!ThriftBooks is a fully independent seller of used books, having ...
See more
Visit shopContact

Detailed seller ratings

Average for the last 12 months
Accurate description
4.9
Reasonable postage cost
5.0
Delivery time
5.0
Communication
4.9

Popular categories from this shop

See allcategories
Books, Comics & Magazines

Seller Feedback (5,686,685)

All ratings
Positive
Neutral
Negative
  • c***m (410)- Feedback left by buyer.
    Past 6 months
    Verified purchase
    WOW!; I cannot believe this 3 Days to Hawaii! ; AAA+++; Excellent Service; Great Pricing; Fast Delivery-Faster Than Expected to Hawaii!; Shipped 05/05, Mon, Received 05/08, Thu to Hawaii using free shipping; USPS Ground Mail, Book in Excellent Condition--Better Than Described ; TLC Packaging; Excellent Seller Communication, Sends updates . Highly Recommended!, Thank you very much!
    The Internment of Japanese Americans During World War II (#146005407795)
  • a***r (375)- Feedback left by buyer.
    Past month
    Verified purchase
    i am so happy to have every book of this series! the price of the book & the shipping is very reasonable! the book was as described & was in excellent condition! it was shipped quickly & arrived quickly! the books are always packaged carefully so they arrived undamaged! the communication from the sellers is always excellent--they go out of their way for excellent customer service! i have been a repeat customer from this seller & always will be! this seller is the best bookseller on ebay!
    The Scottie Barked at Midnight by Dunnett, Kaitlyn (#146243468651)
  • l***b (331)- Feedback left by buyer.
    Past month
    Verified purchase
    5 STARS on ALL aspects... ITEM AS DESCRIBED - 5 STARS... PACKAGING & SHIPPING - 5 STARS... VALUE OF ITEM RECEIVED - 5 STARS... COMMUNICATION - 5 STARS. Would highly recommend this seller to all Ebay buyers without any reservations. Thanks again for your business with BB812, and we do appreciate your care and consideration of our offer. HAPPY EBAY LIFE !!!
    Times Never Forgotten A History of the Central Attendance District 1824 To... (#144168923496)
See all Feedback

More to explore: