New Transact SQL Video Tutorial: How to Choose Whether to Use a Function, a View or a Stored Procedure

How to Choose Whether to Use a Function, a View or a Stored Procedure - view details

For a lot of people just getting started with SQL Server, understanding when to use each of the various objects can be quite a challenge. In this video, resident SQL Server trainer Scott Whigham talks to you about how he uses each of these objects and provides context for using them.

Understand that everyone uses these objects in different ways: some prefer views to functions and procs to everything else. There is no one-size-fits-all approach but, the more you understand the nuances and reasons behind each, the better prepared you'll be to handle any situation thrown at you!

---

• Source: http://www.LearnTransac tSQL.com
• Category: User-Defined Functions (UDFs) in SQL Server
• Skill Level: 300 (Intermediate)
• Length: 15:30 (10.6MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: p roc, udf