1.创建程序集

Create assembly Base64

AUTHORIZATION [dbo]

from 'C:\金税接口\DLL\Base64.dll'

with permission_set = unsafe

2.创建自定义函数（顺丰）

Create Function GetKMRoute(@Freighter nvarchar(20),@waybillNo nvarchar(20),@strcheckPhoneNo nvarchar(20),@key nvarchar(20),@customer nvarchar(50),@isTrace bit)

Returns nvarchar(max) 

As

External Name Base64.UserDefinedFunctions.GetKMRoute

3.调用（顺丰）

select [dbo].[GetKMRoute]('jd','JDX024159630938','18116295499','olZITxTH6115','5664E46DA86EDED0D36FA62AD34B5D32',1)

2.创建自定义函数（KM100）

Create Function GetSFRoute(@waybillNo nvarchar(20),@strcheckPhoneNo nvarchar(20),@isTrace bit)

Returns nvarchar(max) 

As

External Name Base64.UserDefinedFunctions.GetSFRoute

3.调用（KM100）

select [dbo].[GetSFRoute]('SF1527807595054','13901742941',1)