Transact-SQL Programming: Covers Microsoft SQL Server 6.5 /7.0 and Sybase Adaptive Server 11.5 [With CDROM]

Kline, Kevin; Gould, Lee; Zanevsky, Andrew

ISBN 10: 1565924010 ISBN 13: 9781565924017
Verlag: O'Reilly Media, 1999
Gebraucht Paperback

Verkäufer ThriftBooks-Dallas, Dallas, TX, USA Verkäuferbewertung 5 von 5 Sternen 5 Sterne, Erfahren Sie mehr über Verkäufer-Bewertungen

AbeBooks-Verkäufer seit 2. Juli 2009


Beschreibung

Beschreibung:

Pages are clean and are not marred by notes or folds of any kind. ~ ThriftBooks: Read More, Spend Less 2.65. Bestandsnummer des Verkäufers G1565924010I2N00

Diesen Artikel melden

Inhaltsangabe:

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.

Über die Autorin bzw. den Autor: Kevin Kline administrates well over 100 SQL Server installations across the country for Deloitte & Touche LLP. When he's not pulling out his hair, he likes to spend time with his wife and kids, play classical guitar, restore his '66 Chevy truck, and write screenplays. Kevin is also the author of Oracle CDE: Reference & User's Guide (Butterworth-Heinemann) and a coauthor of Professional SQL Server 6.5 Admin (WROX Press). Kevin is also an instructor at Ziff-Davis University (www.zdu.com). He can be reached at kekline@compuserve.com. Lee Gould is a principal consultant with Sybase Professional Services in New York where she works mainly in the financial services industry on Wall Street. She has been working with SQL Server since 1992 and has been involved in the computer industry for over ten years. She has published numerous articles in Microsoft SQL Server Professional (Pinnacle Publishing) and presented on a variety of topics at the International Sybase User Group and Powersoft conferences. Lee was born in Liverpool, England. She grew up in Johannesburg, South Africa, where she attended the University of Witwatersrand and received her bachelors of commerce in business information systems. Lee immigrated to America four years ago and is currently pursuing an MBA at Seton Hall University in New Jersey. Lee lives in the suburb of North Brunswick, New Jersey, with her two cats, Lady and Paganini. She can often be seen running, cycling, swimming, and horseriding while she trains for marathons and ultra triathlon events. When not immersed in sport, Lee is an avid fan of classical music, good wine, the piano, science fiction and Terminator II. Her motto on life is "carpe diem," which she endeavors to follow regardless of where it leads her. Lee can be contacted at lee_k_gould@yahoo.com. Andrew Zanevsky, an independent consultant and founder and president of AZ Databases, Inc., has been working with SQL Server since 1992. He writes a monthly column "Super Administrator," for Microsoft SQL Server Professional (Pinnacle Publishing) and has published more than a hundred technical articles throughout his career. He immigrated to the United States from Minsk, Belarus in 1991. He started programming in 1982 and holds a degree from the Belarus State University of Informatics and Radioelectronics (equivalent to an M.S. in computer science). Andrew lives in a suburb of Chicago with his wife Katrin, son Anthony, and stepdaughter Esther. Katrin is also a SQL Server consultant. They work on some projects together and can talk about Transact-SQL at dinner. Andrew's daughter Nikkie lives in New York, wants to be a writer, and has won numerous awards in art contests. Andrew was the president of the Great Lakes SQL Server Users Group in Chicago from 1994 through 1997. He can be reached at zanevsky@azdatabases.com.

„Über diesen Titel“ kann sich auf eine andere Ausgabe dieses Titels beziehen.

Bibliografische Details

Titel: Transact-SQL Programming: Covers Microsoft ...
Verlag: O'Reilly Media
Erscheinungsdatum: 1999
Einband: Paperback
Zustand: As New
Zustand des Schutzumschlags: No Jacket

Beste Suchergebnisse beim ZVAB

Foto des Verkäufers

Kline, Kevin
Verlag: Oâ²Reilly, 1999
ISBN 10: 1565924010 ISBN 13: 9781565924017
Gebraucht Softcover

Anbieter: WeBuyBooks, Rossendale, LANCS, Vereinigtes Königreich

Verkäuferbewertung 5 von 5 Sternen 5 Sterne, Erfahren Sie mehr über Verkäufer-Bewertungen

Zustand: Good. Most items will be dispatched the same or the next working day. A copy that has been read but remains in clean condition. All of the pages are intact and the cover is intact and the spine may show signs of wear. The book may have minor markings which are not specifically mentioned. Artikel-Nr. wbs4717703872

Verkäufer kontaktieren

Gebraucht kaufen

EUR 5,54
EUR 11,27 shipping
Versand von Vereinigtes Königreich nach USA

Anzahl: 1 verfügbar

In den Warenkorb

Beispielbild für diese ISBN

Kline, Kevin, Zanevsky, Andrew, Gould, Lee
ISBN 10: 1565924010 ISBN 13: 9781565924017
Gebraucht Softcover Erstausgabe

Anbieter: Better World Books, Mishawaka, IN, USA

Verkäuferbewertung 5 von 5 Sternen 5 Sterne, Erfahren Sie mehr über Verkäufer-Bewertungen

Zustand: Good. 1st Edition. Used book that is in clean, average condition without any missing pages. Artikel-Nr. GRP75788051

Verkäufer kontaktieren

Gebraucht kaufen

EUR 6,65
Versand gratis
Versand innerhalb von USA

Anzahl: 1 verfügbar

In den Warenkorb

Beispielbild für diese ISBN

-
Verlag: -, 1999
ISBN 10: 1565924010 ISBN 13: 9781565924017
Gebraucht Paperback

Anbieter: AwesomeBooks, Wallingford, Vereinigtes Königreich

Verkäuferbewertung 5 von 5 Sternen 5 Sterne, Erfahren Sie mehr über Verkäufer-Bewertungen

Paperback. Zustand: Very Good. Transact-SQL Programming: Covers Microsoft SQL Server 6.5 /7.0 and Sybase Adaptive Server 11.5 This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Artikel-Nr. 7719-9781565924017

Verkäufer kontaktieren

Gebraucht kaufen

EUR 7,02
EUR 5,68 shipping
Versand von Vereinigtes Königreich nach USA

Anzahl: 2 verfügbar

In den Warenkorb

Beispielbild für diese ISBN

-
Verlag: - -, 1999
ISBN 10: 1565924010 ISBN 13: 9781565924017
Gebraucht Paperback

Anbieter: Bahamut Media, Reading, Vereinigtes Königreich

Verkäuferbewertung 5 von 5 Sternen 5 Sterne, Erfahren Sie mehr über Verkäufer-Bewertungen

Paperback. Zustand: Very Good. This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Artikel-Nr. 6545-9781565924017

Verkäufer kontaktieren

Gebraucht kaufen

EUR 7,05
EUR 7,95 shipping
Versand von Vereinigtes Königreich nach USA

Anzahl: 1 verfügbar

In den Warenkorb

Beispielbild für diese ISBN

Kline, Kevin; Gould, Lee; Zanevsky, Andrew
Verlag: O'Reilly Media, 1999
ISBN 10: 1565924010 ISBN 13: 9781565924017
Gebraucht Paperback

Anbieter: ThriftBooks-Dallas, Dallas, TX, USA

Verkäuferbewertung 5 von 5 Sternen 5 Sterne, Erfahren Sie mehr über Verkäufer-Bewertungen

Paperback. Zustand: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less. Artikel-Nr. G1565924010I4N00

Verkäufer kontaktieren

Gebraucht kaufen

EUR 7,78
Versand gratis
Versand innerhalb von USA

Anzahl: 1 verfügbar

In den Warenkorb