T-SQL Programming

T-SQL Programming : Inside Microsoft SQL Server 2008

By (author) , By (author) , By (author) , By (author) , By (author) , By (author)


You save US$19.07

Free delivery worldwide

Dispatched from the UK in 2 business days

When will my order arrive?


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.

show more

Product details

  • Paperback | 832 pages
  • 188 x 226 x 52mm | 1,578.49g
  • Microsoft Press,U.S.
  • Redmond, United States
  • English
  • black & white illustrations
  • 0735626022
  • 9780735626027
  • 392,645

About Isaac Kunen

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.

show more