Wintersalen Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Original Essays | November 7, 2014

    Carli Davidson: IMG Puppies for Sale? Read This First



    Shake Puppies contains an almost unsettling amount of cuteness. There is a good chance after looking through its pages you will get puppy fever and... Continue »
    1. $12.59 Sale Hardcover add to wish list

      Shake Puppies

      Carli Davidson 9780062351722

    spacer
Qualifying orders ship free.
$52.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
25 Remote Warehouse Database- Design

Pro T-SQL 2008 Programmer's Guide

by

Pro T-SQL 2008 Programmer's Guide Cover

 

Synopses & Reviews

Publisher Comments:

Discussing new and existing features, SQL Server designer and administrator Michael Coles takes you on an expert guided tour of Transact?SQL functionality in SQL Server 2008 in his book, Pro T?SQL 2008 Programmer's Guide. Fully functioning examples and downloadable source code bring Coles? technically accurate and engaging treatment of Transact?SQL into your own hands. Step?by?step explanations ensure clarity, and an advocacy of best?practices will steer you down the road to success.

Pro T?SQL 2008 Programmer's Guide is every developer's key to making full use of SQL Server 2008's powerful, built?in Transact?SQL language. Transact?SQL is the language developers and DBAs use to interact with SQL Server. It's used for everything from querying data, to writing stored procedures, to managing the database. New features in SQL Server 2008 include a spatial data type, SQLCLR integration, the MERGE statement, a dramatically improved and market?leading XML feature set, and support for encryption?all of which are covered in this book What you?ll learn Write stored procedures, functions, and triggers using Transact?SQL Apply best?practices when centralizing procedural logic inside your SQL Server databaseSeamlessly work with XML data using XQuery, XPath, and the XML typeUse SQLCLR to write .NET code that runs inside SQL ServerImplement full?text search within your databaseLoad data more efficiently using the MERGE statementLearn about the new geography type for storing spatial data Who this book is for

Pro T?SQL 2008 Programmer's Guide is written for SQL Server and Transact?SQL developers who want to implement best?practices and take full advantage of all that SQL Server has to offer. .NET programmers will find the book helpful in showing how to run .NET code within SQL Server. Database administrators who need to write triggers and the occasional stored procedure will also benefit from the book.

Book News Annotation:

This tutorial describes and demonstrates new T-SQL features with working examples, and can be used as a reference for quickly locating details about specific features. The book addresses the needs of three types of readers: SQL developers coming from other platforms to SQL Server, SQL developers moving from prior versions of SQL Server to the 2008 version, and DBAs and nondevelopers who need a working knowledge of T-SQL functionality to support SQL Server 2008 instances. Coverage includes some basics of T-SQL, new simple and advanced features, SQL Server client-side connectivity, and Microsoft's new LINQ to SQL technology. About 150 code samples, written in T-SQL and C#, are provided, most based on the freely available AdventureWorks 2008 sample database. Readers should have a working knowledge of SQL, preferably T-SQL on SQL Server 2005 or 2000. Because sample code in C# is provided and explained in detail, a working knowledge of C# and the .NET Framework is useful, but not required. Chapter exercises are included. Coles is a business intelligence consultant. Annotation ©2008 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

Skill with the Transact-SQL language is key to any developer making use of Microsoft SQL Server. Written especially for developers, the Pro T-SQL 2008 Programmera (TM)s Guide shows developers the full range of whata (TM)s possible using the language. Readers become fully-grounded in the language, in the key features that SQL Server has to offer, and they are introduced to best-practices that will help ensure their success.

Product Details

ISBN:
9781430210016
Author:
Coles, Michael
Publisher:
Apress
Subject:
Programming - Software Development
Subject:
Database Management - SQL Server
Subject:
Sql (computer program language)
Subject:
Database-SQL
Subject:
Database design
Series:
Expert's Voice in SQL Server
Publication Date:
20080831
Binding:
TRADE PAPER
Language:
English
Illustrations:
Y
Pages:
659
Dimensions:
9.18x7.12x1.42 in. 2.37 lbs.

Related Subjects

Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management

Pro T-SQL 2008 Programmer's Guide New Trade Paper
0 stars - 0 reviews
$52.99 In Stock
Product details 659 pages Apress - English 9781430210016 Reviews:
"Synopsis" by , Skill with the Transact-SQL language is key to any developer making use of Microsoft SQL Server. Written especially for developers, the Pro T-SQL 2008 Programmera (TM)s Guide shows developers the full range of whata (TM)s possible using the language. Readers become fully-grounded in the language, in the key features that SQL Server has to offer, and they are introduced to best-practices that will help ensure their success.
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.