Click here to Skip to main content
15,910,210 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
Hi.
I used follow statement to enable clr and use external assembly in sql server 2012.
SQL
EXEC sp_configure 'clr enabled' , '1' 
go 
reconfigure; 

CREATE ASSEMBLY PersianSQLFunctions 
FROM 'D:\MetaJoin\Component\PersianSQLFunctions.dll'

CREATE FUNCTION ToPersianDateTime 
( 
@dt DateTime 
) 
RETURNS NVARCHAR(19) 
AS EXTERNAL NAME PersianSQLFunctions.UserDefinedFunctions.ToPersianDateTime 
CREATE FUNCTION ToPersianDate 
( 
@dt DateTime 
) 
RETURNS NVARCHAR(10) 
AS EXTERNAL NAME PersianSQLFunctions.UserDefinedFunctions.ToPersianDate 


this work in sql server but not work in sqllocalDb.
How do i do?
thx.
Posted
Updated 12-Aug-14 21:37pm
v2

1 solution

Hi,

Check this....


Enabling CLR Integration[^]


Hope this will help you.


Cheers
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900