/*
ext 的部署脚本
此代码由工具生成。
如果重新生成此代码，则对此文件的更改可能导致
不正确的行为并将丢失。
*/
GO
SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON;
SET NUMERIC_ROUNDABORT OFF;
GO
:setvar DatabaseName "ext"
:setvar DefaultFilePrefix "ext"
:setvar DefaultDataPath "C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\"
:setvar DefaultLogPath "C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\"
GO
:on error exit
GO
/*
请检测 SQLCMD 模式，如果不支持 SQLCMD 模式，请禁用脚本执行。
要在启用 SQLCMD 模式后重新启用脚本，请执行:
SET NOEXEC OFF;
*/
:setvar __IsSqlCmdEnabled "True"
GO
IF N'$(__IsSqlCmdEnabled)' NOT LIKE N'True'
BEGIN
PRINT N'要成功执行此脚本，必须启用 SQLCMD 模式。';
SET NOEXEC ON;
END
GO
USE [$(DatabaseName)];
GO
PRINT N'正在删除 [dbo].[Joint]...';
GO
DROP AGGREGATE [dbo].[Joint];
GO
PRINT N'正在删除 [dbo].[FileSize]...';
GO
DROP FUNCTION [dbo].[FileSize];
GO
PRINT N'正在删除 [dbo].[FileMove]...';
GO
DROP FUNCTION [dbo].[FileMove];
GO
PRINT N'正在删除 [dbo].[FileCopy]...';
GO
DROP FUNCTION [dbo].[FileCopy];
GO
PRINT N'正在删除 [dbo].[FileDelete]...';
GO
DROP FUNCTION [dbo].[FileDelete];
GO
PRINT N'正在删除 [dbo].[FileRead]...';
GO
DROP FUNCTION [dbo].[FileRead];
GO
PRINT N'正在删除 [dbo].[FileWirte]...';
GO
DROP FUNCTION [dbo].[FileWirte];
GO
PRINT N'正在删除 [dbo].[ConvertType]...';
GO
DROP FUNCTION [dbo].[ConvertType];
GO
PRINT N'正在删除 [dbo].[TextFormat]...';
GO
DROP FUNCTION [dbo].[TextFormat];
GO
PRINT N'正在删除 [dbo].[Variable]...';
GO
DROP FUNCTION [dbo].[Variable];
GO
PRINT N'正在删除 [dbo].[VariableText]...';
GO
DROP FUNCTION [dbo].[VariableText];
GO
PRINT N'正在删除 [dbo].[VariableDecimal]...';
GO
DROP FUNCTION [dbo].[VariableDecimal];
GO
PRINT N'正在删除 [dbo].[VariableDateTime]...';
GO
DROP FUNCTION [dbo].[VariableDateTime];
GO
PRINT N'正在删除 [dbo].[VariableAssign]...';
GO
DROP FUNCTION [dbo].[VariableAssign];
GO
PRINT N'正在删除 [dbo].[VariableClear]...';
GO
DROP FUNCTION [dbo].[VariableClear];
GO
PRINT N'正在删除 [dbo].[DownloadFile]...';
GO
DROP FUNCTION [dbo].[DownloadFile];
GO
PRINT N'正在删除 [dbo].[DownloadFileCache]...';
GO
DROP FUNCTION [dbo].[DownloadFileCache];
GO
PRINT N'正在删除 [dbo].[RegexIsMatch]...';
GO
DROP FUNCTION [dbo].[RegexIsMatch];
GO
PRINT N'正在删除 [dbo].[RegexReplace]...';
GO
DROP FUNCTION [dbo].[RegexReplace];
GO
PRINT N'正在删除 [dbo].[GetText]...';
GO
DROP FUNCTION [dbo].[GetText];
GO
PRINT N'正在删除 [dbo].[GetDecimal]...';
GO
DROP FUNCTION [dbo].[GetDecimal];
GO
PRINT N'正在删除 [dbo].[GetDateTime]...';
GO
DROP FUNCTION [dbo].[GetDateTime];
GO
PRINT N'正在删除 [dbo].[FileTree]...';
GO
DROP FUNCTION [dbo].[FileTree];
GO
PRINT N'正在删除 [dbo].[Variables]...';
GO
DROP FUNCTION [dbo].[Variables];
GO
PRINT N'正在删除 [dbo].[SequenceDecimal]...';
GO
DROP FUNCTION [dbo].[SequenceDecimal];
GO
PRINT N'正在删除 [dbo].[SequenceDateTime]...';
GO
DROP FUNCTION [dbo].[SequenceDateTime];
GO
PRINT N'正在删除 [dbo].[ExcelFile]...';
GO
DROP FUNCTION [dbo].[ExcelFile];
GO
PRINT N'正在删除 [dbo].[CsvText]...';
GO
DROP FUNCTION [dbo].[CsvText];
GO
PRINT N'正在删除 [dbo].[RegexSplit]...';
GO
DROP FUNCTION [dbo].[RegexSplit];
GO
PRINT N'正在删除 [dbo].[RegexMatch]...';
GO
DROP FUNCTION [dbo].[RegexMatch];
GO
PRINT N'正在删除 [dbo].[HtmlPath]...';
GO
DROP FUNCTION [dbo].[HtmlPath];
GO
PRINT N'正在删除 [dbo].[JsonPath]...';
GO
DROP FUNCTION [dbo].[JsonPath];
GO
PRINT N'正在删除 [SQLExtension]...';
GO
DROP ASSEMBLY [SQLExtension];
GO
PRINT N'正在创建 [SQLExtension]...';
GO
CREATE ASSEMBLY [SQLExtension]
AUTHORIZATION [dbo]
FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C010300293EEC5F0000000000000000E00022200B013000004600000006000000000000A664000000200000008000000000001000200000000200000400000000000000040000000000000000C000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000546400004F00000000800000B80200000000000000000000000000000000000000A000000C0000001C6300001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000B4440000002000000046000000020000000000000000000000000000200000602E72737263000000B8020000008000000004000000480000000000000000000000000000400000402E72656C6F6300000C00000000A0000000020000004C0000000000000000000000000000400000420000000000000000000000000000000088640000000000004800000002000500EC3A00003028000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001330010022000000010000110002730800000A0A066F0900000A0B072C09066F0A00000A0C2B05156A0C2B00082A00001330020054000000020000110002730800000A0A066F0900000A0B072C380003730800000A0C086F0B00000A6F0900000A16FE010D092C0C086F0B00000A6F0C00000A0006036F0D00000A00066F0A00000A13042B0700156A13042B0011042A1330020054000000020000110002730800000A0A066F0900000A0B072C380003730800000A0C086F0B00000A6F0900000A16FE010D092C0C086F0B00000A6F0C00000A0006036F0E00000A26066F0A00000A13042B0700156A13042B0011042A133001002B000000010000110002730800000A0A066F0900000A0B072C1100066F0F00000A00066F0A00000A0C2B0600156A0C2B00082A00133002002100000003000011000203281000000A2D0803281100000A2B05281200000A281300000A0A2B00062A0000001330020052000000040000110002730800000A0A066F0B00000A6F0900000A16FE010C082C0C066F0B00000A6F0C00000A0004281000000A2D0804281100000A2B05281200000A036F1400000A0B0207281500000A00078E6A0D2B00092A0000133003001200000005000011000203731600000A28080000060A2B00062A00001330080010010000060000110002731700000A0A00066F1800000A0B160C2B5A07089A0D00041C8D050000012516096F1900000AA22517096F1A00000AA2251A096F1B00000A8C0D000001A2251B096F1C00000A8C0D000001A26F1D00000A2603130411042C0E096F1900000A0304280800000626000817580C08078E6932A000066F1E00000A13051613062B7B110511069A130700041C8D05000001251611076F1900000AA2251711076F1A00000A1611076F1A00000A1F2E6F1F00000A6F2000000AA2251811076F2100000AA2251911076F0A00000A8C3B000001A2251A11076F1B00000A8C0D000001A2251B11076F1C00000A8C0D000001A26F1D00000A2600110617581306110611058E693F7AFFFFFF0413082B0011082A1330030054000000070000110002740200001B0A0306169A7438000001510406179A7438000001510506189A7438000001510E0406199AA50300001B810300001B0E05061A9AA50D000001810D0000010E06061B9AA50D000001810D0000012A13300300D70300000800001100020A026F2200000A0B076F2300000A0C0828300000060D0920E55124653574092052F23329352A09207D455E093B110100002B0009206AC0E70D3BD60100002B00092052F233293B36010000383D03000009200A314A38351D092097B00E2A3B9C0100002B0009200A314A383B2601000038180300000920B2F1B6473B550100002B000920E55124653B5D01000038FB0200000920F244399C353F09201CE81890351A0920525804842E6E2B0009201CE818903B8701000038D102000009209074EC9B3B620100002B000920F244399C3B8300000038B402000009203FEFAAC7351D09203E8D8CC23B800000002B0009203FEFAAC73BB2000000388F0200000920517FAFD33BB70000002B000920BDFD94FD2E1A3875020000087201000070282400000A3A2B0100003860020000087215000070282400000A3A2B010000384B02000008722B000070282400000A3A30010000383602000008723B000070282400000A3A350100003821020000087253000070282400000A3A3A010000380C020000087269000070282400000A3A3F01000038F701000008727D000070282400000A3A4401000038E201000008728D000070282400000A3A4901000038CD01000008729F000070282400000A3A4B01000038B80100000872B1000070282400000A3A4D01000038A30100000872C3000070282400000A3A4F010000388E0100000872D500007028240000
mysql拼接字符串函数.zip
需积分: 3 122 浏览量
2022-12-17
17:14:08
上传
评论
收藏 463KB ZIP 举报
mysql拼接字符串函数.zip （23个子文件） 
SqlFunctionExtension-master SQLExtension 
RegexFunction.cs 2KB SQLExtension.sqlproj 5KB JsonFunction.cs 2KB HtmlFunction.cs 6KB TextFunction.cs 3KB JointAggregate.cs 956B CellFunction.cs 7KB FileFunction.cs 5KB bin Debug SQLExtension.dll 20KB SQLExtension.sql 52KB ICSharpCode.SharpZipLib.dll 196KB ExcelDataReader.dll 157KB SQLExtension_Create.sql 49KB Newtonsoft.Json.dll 540KB HtmlAgilityPack.dll 115KB ExcelFunction.cs 2KB SpliceAggregate.cs 957B VariableFunction.cs 3KB SequenceFunction.cs 2KB ExecuteProcedure.cs 10KB DownloadFunction.cs 3KB ReadMe.sql 10KB SQLExtension.sln 2KB资源评论
m0_72731342
- 粉丝: 2
- 资源: 1832
