sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

CREATE ASSEMBLY MyAssemblyName
FROM 'C:\DotNet\MyProject.dll'
GO


CREATE PROCEDURE [dbo].[GetSum]
@x int ,@y int
AS
EXTERNAL NAME
MyProject.StoredProcedures.GetSum
GO