Tous nos rayons

Déjà client ? Identifiez-vous

Mot de passe oublié ?

Nouveau client ?

Professional SQL Server 2005 CLR Programming

Librairie Eyrolles - Paris 5e

Professional SQL Server 2005 CLR Programming

Professional SQL Server 2005 CLR Programming

With Stored Procedures, Functions, Triggers, Aggregates, and Types

Derek Comingore, Douglas Hinson - Collection Programmer to Programmer

410 pages, parution le 19/12/2006


SQL Server 2005 offers the capability to write code in a .NET language that can be compiled and run inside SQL Server. CLR Integration, or SQL CLR, lets you create stored procedures, user-defined types, triggers, table valued functions, and aggregates using a .NET managed language. You can read and write to resources outside of SQL Server and enjoy a tighter integration with XML, web services, and simple file and logging capabilities.

Here's the reference you'll want on your desk as you develop SQL CLR solutions. It helps you decide whether to use SQL CLR, how to lock down security, and learn from real examples. If you want to develop stored procedures or other objects in .NET for SQL Server 2005, this book offers exactly what you need.

What you will learn from this book

  • The concepts and architecture of SQL CLR
  • Uses of .NET namespaces in SQL Server programming tasks
  • How to develop and benchmark routines in T-SQL and .NET to determine when CLR-based solutions are advantageous
  • How to replace extended stored procedures using SQL CLR stored procedures
  • How to use SQL CLR objects in external applications
  • How to restrict and secure SQL CLR object capabilities
  • Processes and procedures for deploying SQL CLR objects

Who this book is for

This book is for developers and architects who are familiar with .NET concepts as well as DBAs who, although developers in their own right, may be slightly less up to date on .NET. A solid grounding in T-SQL is necessary.

L'auteur - Derek Comingore

Derek Comingore is the software development manager for He holds the MCAD/MCDBA Microsoft certifications, the Carnegie Mellon Personal Software Process (PSP) credential, and an AAS/BS in Computer Information Systems. In addition to his role for, Derek enjoys writing articles for's newsletter and has written his first article for MSDN (soon to be published) on leveraging SQL Server 2005 Service Broker to obtain real-time ETL. He is also starting up a new SQL Server community,, which promises to deliver a rich and rewarding experience for the SQL Server professional.


  • Introducing SQL CLR
  • Your First CLR Stored Procedure
  • SQL CLR Structure and Common Tasks
  • Creating SQL CLR Objects
  • Comparing T-SQL with Managed Code
  • Replacing Extended Stored Procedures, Functions, and Other T-SQL Objects
  • The .NET Framework's Base Class Library
  • Using SQL CLR Stored Procedures in Your Applications Handling Errors in CLR Stored Procedures
  • CLR Administration and Security Case Study
  • Index
Voir tout

Caractéristiques techniques

Éditeur(s) Wrox Press
Auteur(s) Derek Comingore, Douglas Hinson
Collection Programmer to Programmer
Parution 19/12/2006
Nb. de pages 410
Format 18,5 x 23,5
Couverture Broché
Poids 622g
Intérieur Noir et Blanc
EAN13 9780470054031
ISBN13 978-0-470-05403-1


Livraison à partir de 0,01 en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
satisfait ou remboursé
Satisfait ou remboursé
Paiement sécurisé
modes de paiement
Paiement à l'expédition
partout dans le monde
Livraison partout dans le monde
Service clients 0 321 79 56 75
librairie française
Librairie française depuis 1925