Code Centric: T-SQL Programming with Stored Procedures and Triggers - neues Buch

EAN (ISBN-13): 9781893115835
ISBN (ISBN-10): 1893115836
Gebundene Ausgabe
Taschenbuch
Erscheinungsjahr: 2001
Herausgeber: Apress
692 Seiten
Gewicht: 1,216 kg
Sprache: eng/Englisch

Buch in der Datenbank seit 2007-04-10T14:47:03+02:00 (Berlin)
Detailseite zuletzt geändert am 2023-10-30T04:55:08+01:00 (Berlin)
ISBN/EAN: 9781893115835

ISBN - alternative Schreibweisen:
1-893115-83-6, 978-1-893115-83-5
Alternative Schreibweisen und verwandte Suchbegriffe:
Autor des Buches: wells
Titel des Buches: triggers, lines, point, programming projects, procedures, code red, trigger, sql anywhere, rom, code zdf, programming with, code scanner

---

Daten vom Verlag:

Autor/in: Garth Wells
Titel: Code Centric: T-SQL Programming with Stored Procedures and Triggers
Verlag: Apress; APRESS
695 Seiten
Erscheinungsjahr: 2001-01-30
Berkeley; CA; US
Gewicht: 1,338 kg
Sprache: Englisch
64,19 € (DE)
65,99 € (AT)
71,00 CHF (CH)
POD
XXIII, 695 p. 137 illus.

BC; Database Management; Hardcover, Softcover / Informatik, EDV/Informatik; Datenbanken; Verstehen; Extensible Markup Language (XML); Microsoft SQL Server; SQL; SQL programming; T-SQL; Transact-SQL; XML; databases; design; development; language; optimization; programming; structured analysis; testing; Software Engineering/Programming and Operating Systems; Database Management; Software Engineering; Software Engineering; EA

1 Transact-SQL Overview.- 2 Data Types.- 3 Data Definition Language.- 4 DML: SELECT, JOINs, and Control-of-Flow.- 5 DML: Inserting, Updating, and Deleting Data.- 6 Built-In Functions.- 7 User-Defined Functions.- 8 Views.- 9 System Stored Procedures.- 10 Extended Stored Procedures.- 11 User-Defined Stored Procedures.- 12 Triggers.- 13 Procedures and Triggers by Example.- 14 Building an Application.- Appendix A HTML Primer.- Before You Get Started.- Accessing Web Sites.- Maintaining a Hosted Web Site.- HTML Tags.- Tag Fundamentals.- Tag Descriptions.- Tag Attributes.- Creating HTML Pages.- HTML by Example.- Example 1.- Example 2.- Example 3.- Example 4.- Additional Resources.- Before You Go.- Appendix B ASP Primer.- Before You Get Started.- ASP Primer.- ASP Basics.- Working with Databases.- Pulling It All Together.- Additional Internet Resources.- Before You Go.- Appendix C Query Optimization and Application Performance Primer.- Before You Get Started.- Over-Indexing a Database.- The Ramifications of Client-Side Code.- Query Optimization.- Query Optimizer, Indexes, and Search Arguments (SARGs).- Query Optimization Tools in Query Analyzer.- Index Tuning Wizard.- Analyzing a Database.- Analyzing a Query.- Application Design Issues.- Database Design.- Denormalization.- Server-Side Processing.- Indexing Strategy.- Test Throughout the Development Cycle.- Before You Go.- Appendix D XML Primer.- Before You Get Started.- The Origin of XML.- XML Basics.- SQL/XML Primer.- Configuring SQL/XML Support.- Accessing Data via HTTP.- SELECT... FOR XML.- FOR XML Examples.- OPENXML.- Updategrams.- Integrating ASP and XML.- Update Example.- Additional Internet Resources.- Before You Go.