Magnificent Marvel Supersale
 
 

Special Offers see all

Enter to WIN a $100 Credit

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

Visit our stores


    Recently Viewed clear list


    The Powell's Playlist | February 27, 2015

    Kazuo Ishiguro: IMG Kazuo Ishiguro's Playlist for The Buried Giant



    The eight songs on this playlist didn't "inspire" The Buried Giant, nor did I play them out loud while writing. And with the notable exception of... Continue »

    spacer
Qualifying orders ship free.
$30.00
List price: $62.00
Used 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
1 Partner Warehouse Database- SQL

More copies of this ISBN

Sql Server 2000 Stored Procedure Prog. (3RD 06 Edition)

by

Sql Server 2000 Stored Procedure Prog. (3RD 06 Edition) Cover

 

Synopses & Reviews

Please note that used books may not include additional media (study guides, CDs, DVDs, solutions manuals, etc.) as described in the publisher comments.

Publisher Comments:

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-SQLand.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

Synopsis:

Essential for developers and database administrators who use SQL Server 2005 on a daily basis, this volume explains how to take full advantage of stored procedures. Covering the design of stored procedures in both T-SQL and CLR languages such as C# and Visual Basic .NET, this title shows how to develop programmable database objects and scalable Web-based applications.

About the Author

Dejan andScaron;underi¿, MCDBA, is the principal consultant at Trigon Blue, Inc., and the president of the Toronto SQL Server User Group. He specializes in database and application development on the SQL Server platform.

Table of Contents

Chapter 1: The SQL Server 2005 Environment and Tools

Chapter 2: Stored Procedure Design Concepts

Chapter 3: Basic Transact-SQL Programming Constructs

Chapter 4: Functions

Chapter 5: Composite Transact-SQL Constructs: Batches, Scripts, and Transactions

Chapter 6: Error Handling

Chapter 7: Special Types of Stored Procedures

Chapter 8: Views

Chapter 9: Triggers

Chapter 10: User-defined Functions

Chapter 11: Fundamentals of .NET Programming in SQL Server 2005

Chapter 12: Fundamentals of CLR Stored Procedure Development

Chapter 13: CLR Functions and Triggers

Chapter 14: CLR Database Objects Advanced Topics

Chapter 15: Advanced Stored Procedure Programming

Chapter 16: Debugging

Chapter 17: Source Code Management

Chapter 18: Database Deployment

Chapter 19: Security

Chapter 20: Stored Procedures for Web Search Engines

Chapter 21: Interaction with the SQL Server Environment

APPENDIX A: NAMING CONVENTIONS

APPENDIX B: STORED PROCEDURE COMPILATION, STORAGE, AND REUSE

APPENDIX C: DATA TYPES IN SQL SERVER 2005

INDEX

Product Details

ISBN:
9780072262285
Author:
Sunderic
Publisher:
McGraw-Hill/Osborne Media
Author:
Sunderic, Dejan
Subject:
Programming Languages - SQL
Subject:
Client-server computing
Subject:
Relational databases
Subject:
Technical Skills
Subject:
Computer Languages-SQL
Copyright:
Edition Number:
3
Publication Date:
May 2006
Binding:
TRADE PAPER
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Y
Pages:
664
Dimensions:
9.14x7.33x1.52 in. 2.54 lbs.

Other books you might like

  1. SQL Server 2005 Distilled Used Trade Paper $5.98
  2. SQL Server 2005 T-SQL Recipes: A... New Trade Paper $59.99
  3. Inside Microsoft SQL Server(tm)... Used Trade Paper $19.95
  4. Sql Server Security Distilled 2ND... New Trade Paper $49.99
  5. Cryptography in the Database: The... New Trade Paper $54.99

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » Applications
Computers and Internet » Database » SQL
Engineering » Construction » General
Health and Self-Help » Self-Help » General

Sql Server 2000 Stored Procedure Prog. (3RD 06 Edition) Used Trade Paper
0 stars - 0 reviews
$30.00 In Stock
Product details 664 pages McGraw-Hill/Osborne Media - English 9780072262285 Reviews:
"Synopsis" by , Essential for developers and database administrators who use SQL Server 2005 on a daily basis, this volume explains how to take full advantage of stored procedures. Covering the design of stored procedures in both T-SQL and CLR languages such as C# and Visual Basic .NET, this title shows how to develop programmable database objects and scalable Web-based applications.

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.