Code Centric

by Wells, Garth

• ISBN13: 9781893115835
• ISBN10: 1893115836
• Edition: CD
• Format: Paperback
• Copyright: 2001-02-01
• Publisher: Apress

Summary

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 Triggersis 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 2000such as UDFs (user-defined functions)you can use this book effectively for virtually any version of SQL Server6.x, 7.0, or 2000.The book starts with a comprehensive overview of Transact-SQL, and goes on to cover a variety of topics including data types, the SELECT statement and JOIN operations, control-of-flow statements, updating and deleting data, Transact-SQL built-in functions, user-defined functions, and views.The second part provides coverage of the stored procedures and triggers available in SQL Server, including system stored procedures, extended stored procedures, user-defined stored procedures, and triggers.In the third part, Garth explores the database portion of a real-world solution, demonstrating how to create the client-side portion using ASP and ADO. He also shows how to design a database project from start to finish by using a browser-based application from a provided set of specifications. This book showscases more indispensable information about the major components of Microsoft SQL Servers Transact-SQL language than any other book on the market.

Table of Contents

Foreword	xvii
Preface	xix
Acknowledgments	xxiii
Part I Transact-SQL Basics	1	(238)
Transact-SQL Overview	3	(16)
Data Types	19	(16)
Data Definition Language	35	(36)
DML: Select, JOINs, and Control - of - Flow	71	(62)
DML: Inserting, Updating, and Deleting Data	133	(16)
Built - In Functions	149	(44)
User - Defined Functions	193	(20)
Views	213	(26)
Part II Procedures and Triggers	239	(168)
System Stored Procedures	241	(52)
Extended Stored Procedures	293	(24)
User - Defined Stored Procedures	317	(66)
Triggers	383	(24)
Part III Putting SQL to Work	407	(124)
Procedures and Triggers by Example	409	(78)
Building an Application	487	(44)
Appendix A HTML Primer	531	(24)
Appendix B ASP Primer	555	(36)
Appendix C Query Optimization and Application Performance Primer	591	(34)
Appendix D XML Primer	625	(36)
Index	661