Code centric : T-SQL programming with stored procedures and triggers

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. 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

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.

Annotation Covering the major components of Microsoft SQL Server's T-SQL (Transact-SQL) language, and addressing T-SQL basics with special emphasis on stored procedures and triggers, the author provides a comprehensive overview. Loaded with real-world code examples, the author provides readers with numerous practical code examples based on his own experiences that show them the variety of tasks that can be automated with Transact-SQL.