When you buy a used copy YOU SAVE
3.34Kg of CO2
417 litre(s) of Water
0.025 Tree(s)
1 book donated to global literacy projects
Inside Microsoft® SQL Server® 2008: T-SQL Programming (Developer Reference (Paperback))
Inside Microsoft® SQL Server® 2008: T-SQL Programming (Developer Reference (Paperback))
paperback
Published:
23 September, 2009
paperback
Published:
23 September, 2009
Standard worldwide delivery by
Tue, June 16 - Fri, June 19
Order within
0
Condition:
USED
$12.95
RRP
$64.45
You save $51.50 (80%)
Available
2
in stock
FREE Returns within 30 days
Description
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.
More Details
| Type | Book |
|---|---|
| ISBN13 | 9780735626027 |
| ISBN10 | 0735626022 |
| Number Of Pages | 834 |
| Item Weight | 1576 g |
| Product Dimensions | 188 x 52 x 226 mm |
| Publisher / Reseller | MICROSOFT PRESS |
| Format | paperback |
| Edition | 1 |
See More +
Author's Bio
Dejan Sarka is MCT and MCDBA certified and a Microsoft? MVP for SQL Server?. He teaches and consults for Solid Quality Mentors, speaks at TechEd and PASS, and develops OLTP, OLAP, and data mining solutions.