Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET
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
- Paperback: 664 pages
- Publisher: McGraw-Hill Osborne Media; 3 edition (May 18, 2006)
- Language: English
- ISBN-10: 0072262281
- ISBN-13: 978-0072262285
- Format : CHM
- Size : 18,5 mb
Download : Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET
If you enjoyed this post, please consider to leave a comment or subscribe to the feed and get future articles delivered to your feed reader.
Comments
No comments yet.
Leave a comment