Join Martin Guidry for an in-depth discussion in this video Using CLR with SQL Server 2012, part of SQL Server: Triggers, Stored Procedures, and Functions.
- View Offline
- Exercise Files
In order to use .NET code in our SQL Server we must first enable CLR Integration.…CLR Integration is a default feature, but the default is that it is turned off.…So we merely need to turn it on.…We will do this by using the sp_configure command.…The feature we're interested in configuring is called clr enabled.…Notice there is a space in there, no underscore.…We want to set that equal to a value of 1, but the syntax here rather than…use the equal sign so we use a comma.…
So this will reconfigure our server to set clr enabled equal to 1.…After issuing a command like that you have to issue another command called…RECONFIGURE and that should be all we need.…We notice at the bottom it says configuration options clr enabled change from 0 to 1.…So in other word, it went from turned off to turn on.…So that's the first step.…CLR is now enabled for the entire instance of SQL Server.…There's no way to turn this on and turn it off for one particular database.…
It is a setting that applies to the entire server, not just one database.…
- 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.