Inside Microsoft SQL Server 2005: T-SQL Programming

Introduction

This book is targeted at experienced T-SQL programmers and database professionals that need to write or review T-SQL code. The book covers advanced T-SQL programming, assuming that you already have a good grasp of the basic and intermediate levels of the subject matter and are ready to proceed to the next level.

Organization of This Book

This book is the second of two volumes. It covers advanced T-SQL programming. The first volume—Inside Microsoft SQL Server 2005: T-SQL Querying—covers advanced T-SQL querying. The second volume assumes that you read the first, or have equivalent background. For more details about the organization of the two volumes, please see the book's Preface.


Table of Contents

Inside Microsoft SQL Server 2005— T-SQL Programming 
Foreword
Preface
Introduction
Chapter 1 - Datatype-Related Problems, XML, and CLR UDTs
Chapter 2 - Temporary Tables and Table Variables
Chapter 3 - Cursors
Chapter 4 - Dynamic SQL
Chapter 5 - Views
Chapter 6 - User-Defined Functions
Chapter 7 - Stored Procedures
Chapter 8 - Triggers
Chapter 9 - Transactions
Chapter 10 - Exception Handling
Chapter 11 - Service Broker
Appendix A - Companion to CLR Routines
Index 
List of Figures 
List of Tables 
List of Listings 
List of Sidebars

Cover



 附件: 您所在的用户组无法下载或查看附件

Download