• All Products
      • Paperback
      • Hardcover
      • eBook
      • Audiobook

    Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET

    By: Dejan Sunderic

    RRP: $90.99
    Save $13.00
    Date Released

    Instant Download

    Create and Use Stored Procedures for Optimal Database Performance

    Develop complex stored procedures to retrieve, manipulate, update, and delete data. Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET identifies and describes the key concepts, techniques, and best practices you need to master in order to take full advantage of stored procedures using SQL Server's native Transact-SQL and .NET CLR languages. You'll learn to incorporate effective Transact-SQL stored procedures into client or middleware code, and produce CLR methods that will be compiled into CLR stored procedures. This is a must-have resource for all SQL Server 2005 developers.

    Essential Skills for Database Professionals

    Group and execute T-SQL statements using batches, scripts, and transactions

    Create user-defined, system, extended, temporary, global temporary, and remote stored procedures

    Develop and manage stored procedures using C# and Visual Basic .NET

    Implement database access using ADO.NET

    Create CLR user-defined functions and triggers

    Implement reliable debugging and error handling techniques and security measures

    Manage source code in a repository such as Visual SourceSafe

    Create stored procedures for web search engines

    Use system and extended stored procedures to interact with the SQL Server environment

    You might also like

    Accepted Payments
    QBD Proudly Supports

    Need help? Call us on (07) 3291 7444