- Home
- Computers
- Certification Guides
- Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET
Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET
List Price:
$80.00
- Availability: Confirm prior to ordering
- Branding: minimum 50 pieces (add’l costs below)
- Check Freight Rates (branded products only)
Branding Options (v), Availability & Lead Times
- 1-Color Imprint: $2.00 ea.
- Promo-Page Insert: $2.50 ea. (full-color printed, single-sided page)
- Belly-Band Wrap: $2.50 ea. (full-color printed)
- Set-Up Charge: $45 per decoration
- Availability: Product availability changes daily, so please confirm your quantity is available prior to placing an order.
- Branded Products: allow 10 business days from proof approval for production. Branding options may be limited or unavailable based on product design or cover artwork.
- Unbranded Products: allow 3-5 business days for shipping. All Unbranded items receive FREE ground shipping in the US. Inquire for international shipping.
- RETURNS/CANCELLATIONS: All orders, branded or unbranded, are NON-CANCELLABLE and NON-RETURNABLE once a purchase order has been received.
Product Details
Author:
Dejan Sunderic
Format:
Paperback
Publisher:
Osborne (June 8, 2006)
Audience:
General/trade
ISBN-13:
9780072262285
ISBN-10:
0072262281
Weight:
38.88oz
Dimensions:
7.2" x 9" x 1.4"
Case Pack:
10
File:
McGrawHill-MH_ONIX_V30_US_onix30_all(26_05_05)-20260505.xml
Folder:
McGrawHill
As low as:
$61.60
List Price:
$80.00
Publisher Identifier:
P-MCGRAW
Discount Code:
A
Pages:
664
Pub Discount:
55
Imprint:
McGraw Hill
Overview
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
