Join Martin Guidry for an in-depth discussion in this video Understanding the Common Language Runtime (CLR) and the .NET framework, part of SQL Server: Triggers, Stored Procedures, and Functions.
- View Offline
- Exercise Files
Now I would like to talk about a very different technique of creating stored…procedures and functions.…I will create some stored procedures using the .NET framework languages.…In the demos I'll focus on C# which is certainly the most popular language, but…we can also use any of the hundreds of .NET languages C#, VB.NET, F#, J#…IronPython, IronRuby, and many others.…It is possible to write a stored procedure at the .NET framework, because both…the .NET framework and SQL Server are heavily integrated with the Common…Language Runtime, commonly called the CLR.…
However, not every version of the CLR is compatible with every other version.…So here on the screen I have a chart showing some of the compatibility levels.…SQL Server 2005 and 2008 is compatible with the CLR versions 2.0, 3.0, and 3.5.…And SQL Server 2012 we still get 2.0, 3.0, 3.5, but we also additionally get 4.0.…This can lead to some interesting decisions for a developer as to which version…should you write your code in.…
But in many cases it's not that hard to change what version you're an after the fact.…
- Comparing triggers, functions, and stored procedures
- Installing and configuring SQL Server
- Creating a stored procedure
- Returning data using data sets
- Creating user-defined functions
- Using "after," "instead," and nested triggers
- Modifying existing stored procedures
- Implementing logging on DELETE
- Choosing between T-SQL and CLR
- Executing a stored procedure
- Passing parameters
Skill Level Advanced
1. Getting Started
2. Installing SQL Server
Configuring your environment4m 53s
3. Stored Procedures
4. User-Defined Functions
6. Putting It All Together
7. Using CLR Assemblies
8. Exploring an ASP.NET Web Application
Next steps1m 43s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.