Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET
2010
Online
E-Book
Zugriff:
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
Titel: |
Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET
|
---|---|
Autor/in / Beteiligte Person: | Sunderic, Dejan |
Veröffentlichung: | 2010 |
Medientyp: | E-Book |
ISBN: | 978-0-07-226228-5 (print) ; 978-0-07-149170-9 (electronic) |
Schlagwort: |
|
Sonstiges: |
|