• T-SQL Programming: Inside Microsoft SQL Server 2005 See large image

    T-SQL Programming: Inside Microsoft SQL Server 2005 (Solid Quality Learning) (Paperback) By (author) Itzik Ben-Gan, By (author) Dejan Sarka


    Sorry we can't get this title, the button below links through to AbeBooks who may have this title (opens in new window).

    Try AbeBooks | Add to wishlist

    DescriptionGet 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 the programming language-solving complex problems with real-world solutions. Discover how to: * Understand when to apply set-based programming techniques * Design and implement date and time-related XML and CLR datatypes * Use temporary objects, including temporary tables, table variables, and table expressions * Work with T-SQL and CLR user-defined functions, stored procedures, and triggers * Support user input-based queries and variable data with dynamic execution * Work with transactions and new exception handling constructs * Apply a concurrency model to support simultaneous users * Use Service Broker for controlled asynchronous processing in database applications This book includes code samples on the Web.

Other books

Other people who viewed this bought | Other books in this category
Showing items 1 to 10 of 10


Reviews | Bibliographic data
  • Full bibliographic data for T-SQL Programming

    T-SQL Programming
    Inside Microsoft SQL Server 2005
    Authors and contributors
    By (author) Itzik Ben-Gan, By (author) Dejan Sarka
    Physical properties
    Format: Paperback
    Number of pages: 544
    Width: 187 mm
    Height: 235 mm
    Thickness: 34 mm
    Weight: 1,062 g
    ISBN 13: 9780735621978
    ISBN 10: 0735621977

    BIC E4L: COM
    Nielsen BookScan Product Class 3: S10.2
    B&T Book Type: NF
    B&T Modifier: Region of Publication: 01
    B&T Modifier: Subject Development: 20
    B&T Modifier: Academic Level: 01
    BIC subject category V2: UM
    B&T Modifier: Text Format: 01
    B&T General Subject: 227
    BIC subject category V2: UN
    B&T Merchandise Category: COM
    DC22: 005.7565
    Warengruppen-Systematik des deutschen Buchhandels: 16360
    LC subject heading:
    BIC subject category V2: UMT
    LC subject heading: ,
    Ingram Subject Code: XD
    Libri: I-XD
    B&T Approval Code: A93603281
    BISAC V2.8: COM051170, COM021000
    LC subject heading:
    DC22: 005.7585
    B&T Approval Code: A93662400
    LC subject heading:
    DC22: 005.2/768
    LC classification: QA76.9.C55 B457 2006
    Thema V1.0: UMT
    Illustrations note
    black & white illustrations
    Microsoft Press,U.S.
    Imprint name
    Microsoft Press,U.S.
    Publication date
    14 June 2006
    Publication City/Country
    Author Information
    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.
    Table of contents
    Datatype related problms, XML, & CLR UDTs Temporary tables Cursors Dynamic SQL Views User-Defined functions Stored procedures Triggers Transactions Exception handling Service broker