Name: Code Centric: T-SQL Programming with Stored Procedures and Triggers von Garth Wells
SKU: 9781893115835
Price: 16.00 CHF
Availability: InStock

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

Code Centric: T-SQL Programming with Stored Procedures and Triggers Garth Wells

If you want to learn how to write stored procedures and triggers for Microsoft SQL Server, Code Centric: T-SQL Programming with Stored Procedures and Triggers is the book for you. Youll learn real-world coding and how to build non-trivial applications. All of the examples covered in the book are available for download, making it easier to work through over 5,000 lines of sample code.

While there is extensive coverage of the new functionality in SQL Server 2000-such as UDFs (user-defined functions)-you can use this book effectively for virtually any version of SQL Server6.x, 7.0, or 2000.

Über Garth Wells

Garth Wells is president of DataDrivenWebSites.com, Inc., a company that focuses on web-enabling SQL Server databases. He has designed and implemented database solutions for over seven years, and has successfully implemented database solutions in a number of different industries including computer design, medical informatics, and commercial real estate management. Garth has written for Pinnacle Publishing's newsletter SQL Server Professional and he is the co-author of 10 Projects You Can Do with Microsoft SQL Server 7.

Inhaltsverzeichnis

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.

Zusätzliche Informationen

Sku

GOR002875072

ISBN 13

9781893115835

ISBN 10

1893115836

Titel

Code Centric: T-SQL Programming with Stored Procedures and Triggers Garth Wells

Autor

Garth Wells

Zustand

Gebraucht - Sehr Gut

Bindung

Broschiert

Verlag

APress

Datum

20010130

Anzahl der Seiten

695

Preise

N/A

Begleitschreiben

Die Abbildung des Buches dient nur Illustrationszwecken, die tatsächliche Bindung, das Cover und die Auflage können sich davon unterscheiden.

Hinweis

Dies ist ein gebrauchtes Buch. Es wurde schon einmal gelesen und weist von der früheren Nutzung Gebrauchsspuren auf. Wir gehen davon aus, dass es im Großen und Ganzen in einem sehr guten Zustand ist. Sollten Sie jedoch nicht vollständig zufrieden sein, setzen Sie sich bitte mit uns in Verbindung.