Authors: Sunderic, Dejan
Pages: 664
Publisher: Unknow
ISBN13: 9780072262285
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 & execute T-SQL statements using batches, scripts, & transactions;
- Create user-defined, system, extended, temporary, global temporary, & remote stored procedures;
- Develop & manage stored procedures using C# & Visual Basic .NET;
- Implement database access using ADO.NET;
- Create CLR user-defined functions & triggers;
- Implement reliable debugging & error handling techniques & security measures;- Manage source code in a repository such as Visual SourceSafe;
- Create stored procedures for web search engines;
- Use system & extended stored procedures to interact with the SQL Server environment.