Store Procedures. Lesson 9. Skills Matrix. Stored Procedures. Stored procedures in SQL Server are similar to the procedures you write in other programming languages. Specifically, a stored procedure predefines a batch of code that you store as an object in the database to do work.
sp_configure 'clr_enabled', 1