Targeted at software developers who want to develop stored procedures without having to deal with the eccentricities of Transact-SQL (T-SQL), this book show how to build applications using all of the new features of SQL Server 2005
Contrasts the new capabilities available with managed stored procedures (MSPs) against traditional T-SQL
Addresses creating, updating, and deleting managed stored procedures; converting existing T-SQL to MSPs; integrating MSPs within new and existing database applications; and administration and security
A detailed case example shows how a problem set can now be solved with SQL Server 2005, contrasting this solution with older T-SQL-based methods
The companion Web site provides fully working routines that readers can implement in their own applications
This command reference, designed for users of all levels, provides
a user friendly guide to the SQL database programming language. All commands are listed alphabetically by functional area ideal for beginners who can locate commands based on the tasks ...
"Beginning Database Design: From Novice to Professional" provides short, easy
to read explanations of how to get database design right the first time. This book offers numerous examples to help you avoid the many pitfalls that entrap new and ...