Can we call .DLL from SQL server ?
Post date: Mar 4, 2011 7:29:19 AM
sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO
Deploying the Assembly in SQL Server 2008
create ASSEMBLY Encryption1 from 'c:\boobalan\Encrypt.dll' WITH PERMISSION_SET = SAFE
go
Create a function using the Assembly file:
create function [dbo].[Encrypt](
@plainText nvarchar(max),
@passPhrase nvarchar(max),
)
returns nvarchar(max)
AS
//Creating & executing the CLR stored procedure in SQL Server 2008
EXTERNAL NAME Encryption1.DotNetSolution.Encrypt
go
Call the Function Using SQL Command
select @value = dbo.Encrypt('muruga','Pass@123')
select @value