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

Nonfiction, Computers, Database Management, General Computing, Skills
Cover of the book Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET by Dejan Sunderic, McGraw-Hill Education
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Dejan Sunderic ISBN: 9780071491709
Publisher: McGraw-Hill Education Publication: June 9, 2010
Imprint: McGraw-Hill Education Language: English
Author: Dejan Sunderic
ISBN: 9780071491709
Publisher: McGraw-Hill Education
Publication: June 9, 2010
Imprint: McGraw-Hill Education
Language: English

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
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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

More books from McGraw-Hill Education

Cover of the book Executive Toughness: The Mental-Training Program to Increase Your Leadership Performance : The Mental-Training Program to Increase Your Leadership Performance: The Mental-Training Program to Increase Your Leadership Performance by Dejan Sunderic
Cover of the book American Landlord: Everything U Need to Know... about Property Management by Dejan Sunderic
Cover of the book Investing in Gold Mine Houses: How to Uncover a Fortune Fixing Small Ugly Houses and Apartments by Dejan Sunderic
Cover of the book Schaum's Outline of Intermediate Algebra, Third Edition by Dejan Sunderic
Cover of the book Clinical Brain Mapping by Dejan Sunderic
Cover of the book McGraw-Hill's GMAT 2013 Edition by Dejan Sunderic
Cover of the book Field Engineer's Manual by Dejan Sunderic
Cover of the book Schaum's Outline of College Physics, 11th Edition by Dejan Sunderic
Cover of the book Mike Meyers' CompTIA Network+ Certification Passport, Sixth Edition (Exam N10-007) by Dejan Sunderic
Cover of the book CompTIA Security+ Certification Study Guide, Third Edition (Exam SY0-501) by Dejan Sunderic
Cover of the book Science And Beyond The Classroom Boundaries For 7-11 Year Olds by Dejan Sunderic
Cover of the book Qualitative Methods In Psychology: A Research Guide by Dejan Sunderic
Cover of the book CompTIA A+® Certification Practice Exams, Second Edition (Exams 220-801 & 220-802) by Dejan Sunderic
Cover of the book The Paramedic'S Guide To Research: An Introduction by Dejan Sunderic
Cover of the book George Washington's Secret Navy by Dejan Sunderic
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy