{"product_id":"9780071491709","title":"Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL \u0026 .NET","description":"\u003cp\u003e\u003cstrong\u003eCreate and Use Stored Procedures for Optimal Database Performance\u003c\/strong\u003e\u003c\/p\u003e  \u003cp\u003eDevelop complex stored procedures to retrieve, manipulate, update, and delete data\u003cem\u003e. Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL \u0026amp; .NET\u003c\/em\u003e 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.\u003c\/p\u003e  \u003cp\u003eEssential Skills for Database Professionals\u003c\/p\u003e  \u003cul\u003e\n\u003cli\u003eGroup and execute T-SQL statements using batches, scripts, and transactions\u003c\/li\u003e  \u003cli\u003eCreate user-defined, system, extended, temporary, global temporary, and remote stored procedures\u003c\/li\u003e  \u003cli\u003eDevelop and manage stored procedures using C# and Visual Basic .NET\u003c\/li\u003e  \u003cli\u003eImplement database access using ADO.NET\u003c\/li\u003e  \u003cli\u003eCreate CLR user-defined functions and triggers\u003c\/li\u003e  \u003cli\u003eImplement reliable debugging and error handling techniques and security measures\u003c\/li\u003e  \u003cli\u003eManage source code in a repository such as Visual SourceSafe\u003c\/li\u003e  \u003cli\u003eCreate stored procedures for web search engines\u003c\/li\u003e  \u003cli\u003eUse system and extended stored procedures to interact with the SQL Server environment\u003c\/li\u003e  \u003c\/ul\u003e  \u003cp\u003e\u003c\/p\u003e","brand":"McGraw Hill LLC","offers":[{"title":"Default Title","offer_id":47077116805360,"sku":"9780071491709","price":68.4,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780071491709_p0.jpg?v=1763635380","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780071491709","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}