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

✍ Scribed by Garth Wells (auth.)

• Publisher: Apress
• Year: 2001
• Tongue: English
• Leaves: 704
• Edition: 1
• Category: Library

✦ Synopsis

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.

✦ Table of Contents

Front Matter....Pages i-xxiii
Front Matter....Pages 1-1
Transact-SQL Overview....Pages 3-18
Data Types....Pages 19-34
Data Definition Language....Pages 35-70
DML: SELECT, JOINs, and Control-of-Flow....Pages 71-131
DML: Inserting, Updating, and Deleting Data....Pages 133-148
Built-In Functions....Pages 149-191
User-Defined Functions....Pages 193-212
Views....Pages 213-238
Front Matter....Pages 239-239
System Stored Procedures....Pages 241-292
Extended Stored Procedures....Pages 293-315
User-Defined Stored Procedures....Pages 317-382
Triggers....Pages 383-406
Front Matter....Pages 407-407
Procedures and Triggers by Example....Pages 409-485
Building an Application....Pages 487-529
Back Matter....Pages 531-695

✦ Subjects

Software Engineering/Programming and Operating Systems