Cantitate/Preț
Produs
Total produse
Vezi coșul
Code Centric: T-SQL Programming with Stored Procedures and Triggers de Garth Wells

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

Autor Garth Wells
en Limba Engleză Paperback – 30 ian 2001
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.
Citește tot Restrânge

Preț: 30879 lei

Preț vechi: 38599 lei
-20%

Puncte Express: 463

Carte disponibilă

Livrare economică 06-20 iulie

Livrare prin curier în România Termenul estimat este afișat lângă disponibilitate.
Transport gratuit de la 40000 lei Plată online sau ramburs, în funcție de opțiunile comenzii.
Retur gratuit în 14 zile Comandă securizată și suport în română.
 Adaugă în coș

Wish list
Gift list
Am citit!
Adaugă în listă

Specificații

ISBN-13: 9781893115835
ISBN-10: 1893115836
Pagini: 695
Ilustrații: XXIII, 695 p. 137 illus.
Dimensiuni: 190 x 240 x 40 mm
Greutate: 1.26 kg
Ediția:Softcover Reprint of the Original 1st edition
Editura: Apress
Locul publicării:Berkeley, CA, United States

Public țintă

Professional/practitioner

Cuprins

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.

Notă biografică

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.

Caracteristici

More than 5000 lines of real-world code and examples that readers can use immediately Addresses T-SQL basics with special emphasis on stored procedures and triggers Covers the major components of Microsoft SQL Server's T-SQL Includes supplementary material: sn.pub/extras