Read Anywhere and on Any Device!

Subscribe to Read | $0.00

Join today and start reading your favorite books for Free!

Create Free Account

Inside Microsoft SQL Server 2005: T-SQL Programming

4.3/5 ( ratings)

Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of the programming language—solving complex problems with real-world solutions.

Discover how to:

Understand when to apply set-based programming techniques
Design and implement date and time-related XML and CLR datatypes
Use temporary objects, including temporary tables, table variables, and table expressions
Work with T-SQL and CLR user-defined functions, stored procedures, and triggers
Support user input-based queries and variable data with dynamic execution
Work with transactions and new exception handling constructs
Apply a concurrency model to support simultaneous users
Use Service Broker for controlled asynchronous processing in database applications

This book includes code samples on the Web.

Language: English

Pages: 536

Format: Paperback

Publisher: Microsoft Press

Release: May 24, 2006

ISBN: 0735621977

ISBN 13: 9780735621978

Inside Microsoft SQL Server 2005: T-SQL Programming

4.3/5 ( ratings)

Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of the programming language—solving complex problems with real-world solutions.

Discover how to:

Understand when to apply set-based programming techniques
Design and implement date and time-related XML and CLR datatypes
Use temporary objects, including temporary tables, table variables, and table expressions
Work with T-SQL and CLR user-defined functions, stored procedures, and triggers
Support user input-based queries and variable data with dynamic execution
Work with transactions and new exception handling constructs
Apply a concurrency model to support simultaneous users
Use Service Broker for controlled asynchronous processing in database applications

This book includes code samples on the Web.

Language: English

Pages: 536

Format: Paperback

Publisher: Microsoft Press

Release: May 24, 2006

ISBN: 0735621977

ISBN 13: 9780735621978

More books from Roger Wolter

Inside Microsoft SQL Server 2008: T-SQL Programming

4.4/5 ( ratings)

The Rational Guide to SQL Server 2005 Service Broker (Rational Guides)

3.3/5 ( ratings)

The Rational Guide to SQL Server 2005 Service Broker: Beta Preview

Rate this book!

Write a review?