Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET

Dejan Sunderic

ISBN 10: 0072262281 / ISBN 13: 9780072262285

Editore: McGraw-Hill Education 01/06/2006, 2006

Riguardo questo articolo

This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. .

Codice articolo 7719-9780072262285

Dati bibliografici

• Titolo: Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET
• Editore: McGraw-Hill Education 01/06/2006
• Data di pubblicazione: 2006
• Lingua: Inglese
• ISBN 10: 0072262281
• ISBN 13: 9780072262285
• Rilegatura: Brossura
• Edizione: terza edizione
• Condizione: Very Good

Descrizione articolo

Riassunto

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

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

Informazioni sull?autore

Dejan Sunderic (Toronto, Ontario) MCSD is the Principal Consultant at Sage Information Consultants, Inc., a consulting company based in Toronto specializing in development and infrastructure solutions.