Pro T-SQL 2005 Programmer's Guide (Expert's Voice)

Pro T-SQL 2005 Programmer's Guide (Expert's Voice), 9781590597941 (159059794X), Apress, 2007

Pro T-SQL 2005 Programmer's Guide provides comprehensive and detailed coverage of all the major features and facilities of T-SQL for SQL Server 2005. It is designed for all users of T-SQL, database administrators, systems administrators, application developers, and end-users, who want to learn how to exploit the power of T-SQL. Whatever you need to do with T-SQL, you'll find it described clearly here.

Stored procedures, triggers, and user-defined functions are only part of the story. Dynamic SQL, the new XML data type, and SQLCLR programming are also covered, as well as accessing SQL Server with ADO.NET. Exception handling and performance are fully covered, too. This book is truly a complete programmer's guide to T-SQL and SQL Server 2005.

About the Author

Michael Coles has over a decade's experience designing and administering SQL Server databases. A prolific writer of articles on all aspects of SQL Server, particularly on the expert use of T-SQL, he holds MCDBA and MCP certifications. He received a bachelor's of science (magna cum laude) in information technology from American Intercontinental University. A member of the United States Army Reserve, he was activated for two years following 9/11.

Comments

Amazing Books

Arnheim, Gestalt and Art: A Psychological Theory

Springer, 2005

When one hears the words, the ‘psychology of art,’ one is likely to think of the name of Rudolf Arnheim. Because of his great productivity we have been fortunate to hear the latest words of wisdom from this remarkable nonegenarian, almost up to the present day. But while Arnheim the personality is always intriguing, his system risks...

User Interface Design: A Software Engineering Perspective

Addison Wesley, 2005

When you design the user interface to a computer system, you decide which screens the system will show, what exactly will be in each screen and how it will look. You also decide what the user can click on and what happens when he does so, plus all the other details of the user interface. It is the designer’s responsibility that the system has...

Computer and Communication Networks

Prentice Hall, 2006

As the number and variety of communication services grow, so do the challenges of designing cost-effective networks that meet the requirements of emerging technologies in wireless, sensor, and mesh networks. Computer and Communication Networks is the first book to offer balanced coverage of all these topics using...

Mac OS X Security

New Riders Publishing, 2003

Mac OS X now operates on a UNIX engine. As such it is much more powerful than previous operating systems. It is now a multitasking, multithreaded, multi-user, and multiprocessor system with enhanced interoperability with other systems. Along with that increased power comes increased security vulnerability. Part I introduces readers to the basics of...

Chemically Bonded Phosphate Ceramics: Twenty-First Century Materials with Diverse Applications

Elsevier Limited, 2005

A single source of for the science and applications of chemically bonded phosphate ceramics

The first chemically bonded phosphate ceramics (zinc phosphate dental cements) were developed over a century ago. However it has only been in the last 30 years that a new breed of materials has been discovered. This book brings...

SUSE Linux 10 For Dummies (Computer/Tech)

For Dummies, 2005

SUSE Linux is an increasingly popular Linux distribution that competes headon
with Red Hat’s Linux versions. SUSE Linux’s fortunes have been on the
rise following Novell’s acquisition of Germany’s SUSE Linux AG and the recent
initiation of the openSUSE project (www.opensuse.org) — an open source...