hytos / ID2.Manager / MarkusSQL / InsertAss.SQL @ 00d11333
이력 | 보기 | 이력해설 | 다운로드 (604 Bytes)
1 |
-- 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;
|