Binding: Paperback EAN: 9780072262285 Edition: 3 ISBN: 0072262281 Item Dimensions:152914254733 Label: McGraw-Hill Osborne Media Languages:EnglishUnknownEnglishOriginal LanguageEnglishPublished Manufacturer: McGraw-Hill Osborne Media Number Of Items: 1 Number Of Pages: 664 Publication Date: May 18, 2006 Publisher: McGraw-Hill Osborne Media Studio: McGraw-Hill Osborne Media
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
(c) copyright 2003-2011 Anventure. All
Rights Reserved. contact us
View Cart or Checkout