属性/方法 | 类型 | 说明/调用示例 |
Base64Encode | function | select dbo.Base64Encode('123123') |
Base64Decode | function | select dbo.Base64Encode('MTIz') |
TableToJson | function | select dbo.TableToJson('select top 1 * table',0) ---返回实体对象{} select dbo.TableToJson('select * table',1) ---返回数据对象[{},{}] |
TResultToJson | function | select dbo.TResultToJson(TResult) |
HttpGet | function | select dbo.HttpGet(url) ---以get方式请求url |
HttpPost | funciton | select dbo.HttpPost(url,'application/json','token=aaaa&referer=1111','{"id":1}') |
HttpPostForm | function | select dbo.HttpPostForm(url,'id=1&name=ted') |
HttpPostJson | function | select dbo.HttpPost(url,'{"id":1}') |
代码演示: