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

Dejan Sunderic (Autor)

eBook Download: EPUB

2010
664 Seiten
McGraw-Hill Education (Verlag)
978-0-07-149170-9 (ISBN)

Infos

Create and Use Stored Procedures for Optimal Database PerformanceDevelop 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 ProfessionalsGroup and execute T-SQL statements using batches, scripts, and transactionsCreate user-defined, system, extended, temporary, global temporary, and remote stored proceduresDevelop and manage stored procedures using C# and Visual Basic .NETImplement database access using ADO.NETCreate CLR user-defined functions and triggersImplement reliable debugging and error handling techniques and security measuresManage source code in a repository such as Visual SourceSafeCreate stored procedures for web search enginesUse system and extended stored procedures to interact with the SQL Server environment

Produkt-Details

• Erscheint lt. Verlag: 9.6.2010
• Sprache: englisch
• Themenwelt: Informatik ► Datenbanken ► SQL Server
• Themenwelt: Mathematik / Informatik ► Informatik ► Software Entwicklung
• ISBN-10: 0-07-149170-8 / 0071491708
• ISBN-13: 978-0-07-149170-9 / 9780071491709