買這商品的人也買了...
-
The Guru's Guide to SQL Server Stored Procedures, XML, and HTML (Paperback)$2,730$2,594 -
C++ Primer, 4/e (中文版)$990$891 -
資料結構 in Java$560$532 -
大話設計模式$620$527 -
數位影像處理 (Digital Image Processing, 3/e)$880$862 -
Thinking in Java 中文版 (Thinking in Java, 4/e)$960$758 -
Microsoft SQL Server 2008 管理實務$680$578 -
Linux Device Driver Programming 驅動程式設計$690$538 -
30 天打造 OS！作業系統自作入門$780$663 -
iPhone SDK 3 App 程式設計$520$442 -
Microsoft Expression Web 3 In Depth (Paperback)$1,670$1,587 -
Microsoft Expression Web 3 On Demand (Paperback)$1,050$998 -
$480Sams Teach Yourself Microsoft Expression Web 3 in 24 Hours (Paperback) -
鳥哥的 Linux 私房菜－基礎學習篇, 3/e$820$648 -
程式設計師的自我修養－連結、載入、程式庫$580$493 -
電腦網路 (Computer Networks: A Systems Approach, 4/e)$800$760 -
巧用 jQuery$490$417 -
約耳趣談軟體－來自專案管理的現場實錄 (Joel on Software: And on Diverse and Occasionally Related Matters That Will Prove of Interest to Software Developers)$490$417 -
Facebook 程式開發經典─讓你設計出成功的 Facebook 應用程式(Essential Facebook Development: Build Successful Applications for the Facebook Platform)$520$411 -
演算法之道─讓你學不會演算法都難$420$332 -
Android 應用開發揭秘$600$510 -
Fedora 14 Linux 實務應用$650$553 -
Android 案例開發完全講義$580$458 -
.NET 網路與 I/O 技術手冊, 2/e$620$527 -
前進 Android Market！Google Android SDK 實戰演練$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.
