Mensys Online Shop
| Categorie: | Algemeen - Boeken | Van: | Microsoft Press |
| Meer informatie: | www.comcol.nl/micros... | Auteur(s): | Itzik Ben-Gan, Dejan Sarka, Roger Wolter, Greg Low, Ed Katibah, Isaac Kunen |
| Bladzijden: | 798 | Publicatie-jaar: | 2010 |
Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference.Database developers & 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 & CLR user defined functions, stored procedures, and triggers;- Handle transactions, concurrency, and error handling;- » Lees meer... | ![]() |
Alle prijzen zijn in Euro excl. BTW (19%, voor boeken 6%) en excl. verzendkosten.
E-mail of bel 023 548 20 20 voor licenties, upgrades en andere vragen.
Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference.Database developers & 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 & 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 & secure manner;- Treat date- and time related data in a robust manner;- Develop CLR user defined types & learn about temporal support in the relational model;- Use XML & XQuery and implement a dynamic schema solution;- Work with spatial data using the new geometry & geography types and spatial indexes;- Track access & 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.

