買這商品的人也買了...
-
$2,750$2,613 -
$990$891 -
$560$532 -
$620$527 -
$880$862 -
$960$691 -
$680$537 -
$690$587 -
$780$663 -
$520$411 -
$1,680$1,596 -
$1,050$998 -
$299Sams Teach Yourself Microsoft Expression Web 3 in 24 Hours (Paperback)
-
$820$590 -
$580$493 -
$800$760 -
$490$417 -
$490$417 -
$520$374 -
$420$302 -
$600$510 -
$650$514 -
$580$418 -
$620$527 -
$850$723
商品描述
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 languagesolving 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.