hytos / ID2.Manager / MarkusSQL / InsertAss.SQL @ b4e4e6c9
이력 | 보기 | 이력해설 | 다운로드 (604 Bytes)
1 | 2581c7b6 | taeseongkim | -- test |
---|---|---|---|
2 | exec sp_configure |
||
3 | |||
4 | exec sp_configure 'clr enabled',1 |
||
5 | reconfigure with override |
||
6 | |||
7 | |||
8 | exec sp_configure 'show advanced options',1 |
||
9 | reconfigure with override |
||
10 | |||
11 | |||
12 | exec sp_configure 'clr strict security',0; |
||
13 | reconfigure with override |
||
14 | |||
15 | |||
16 | USE master; |
||
17 | GO |
||
18 | |||
19 | CREATE ASSEMBLY MarkupDataParse
|
||
20 | FROM 'D:\Markus_V3\dbFunctions\MarkupDataParse.dll' |
||
21 | WITH PERMISSION_SET = SAFE; |
||
22 | |||
23 | |||
24 | select * from sys.assemblies |
||
25 | |||
26 | USE markus_SEC; |
||
27 | GO |
||
28 | |||
29 | CREATE FUNCTION MarkupDataCompress(@inputString NVARCHAR(MAX)) |
||
30 | RETURNS NVARCHAR(MAX)
|
||
31 | AS EXTERNAL NAME MarkupDataParse.[MarkupDataParse.MarkupDataFunctions].CompressString; |