 |


|
 |
Item Details
Title:
|
T-SQL PROGRAMMING
INSIDE MICROSOFT SQL SERVER 2008 |
By: |
Itzik Ben-Gan, Dejan Sarka, Roger Wolter |
Format: |
Paperback |

List price:
|
£47.99 |
We currently do not stock this item, please contact the publisher directly for
further information.
|
|
|
|
|
ISBN 10: |
0735626022 |
ISBN 13: |
9780735626027 |
Publisher: |
MICROSOFT PRESS,U.S. |
Pub. date: |
23 September, 2009 |
Pages: |
832 |
Synopsis: |
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 this programming language-solving complex problems with real-world solutions. Discover how to: * Work with T-SQL and CLR user-defined functions, stored procedures, and triggers. * Handle transactions, concurrency, and error handling. * Efficiently use temporary objects, including temporary tables, table variables, and table expressions. * Evaluate when to use set-based programming techniques and when to use cursors. * Work with dynamic SQL in an efficient and secure manner. * Treat date- and time-related data in a robust manner. * Develop CLR user-defined types and learn about temporal support in the relational model. * Use XML and XQuery and implement a dynamic schema solution. * Work with spatial data using the new geometry and geography types and spatial indexes. * Track access and changes to data using extended events, SQL Server Audit, change tracking, and change data capture.* Use Service Broker for controlled asynchronous processing in database applications. All the book's code samples will be available for download from the companion Web site. |
Publication: |
US |
Imprint: |
Microsoft Press,U.S. |
Returns: |
Returnable |
|
|
|
 |


|

|

|

|

|
Little Worried Caterpillar (PB)
Little Green knows she''s about to make a big change - transformingfrom a caterpillar into a beautiful butterfly. Everyone is VERYexcited! But Little Green is VERY worried. What if being a butterflyisn''t as brilliant as everyone says?Join Little Green as she finds her own path ... with just a littlehelp from her friends.

|

|
All the Things We Carry PB
What can you carry?A pebble? A teddy? A bright red balloon? A painting you''ve made?A hope or a dream?This gorgeous, reassuring picture book celebrates all the preciousthings we can carry, from toys and treasures to love and hope. With comforting rhymes and fabulous illustrations, this is a warmhug of a picture book.

|

|
|
 |