<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[acycwf的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/acycwf</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; acycwf]]></copyright><item><title><![CDATA[查询mssql所有的存储过程创建语句]]></title><link>https://blog.youkuaiyun.com/acycwf/article/details/157396313</link><guid>https://blog.youkuaiyun.com/acycwf/article/details/157396313</guid><author>acycwf</author><pubDate>Mon, 26 Jan 2026 16:00:28 +0800</pubDate><description><![CDATA[OBJECT_DEFINITION(p.object_id) AS [存储过程定义]--     SCHEMA_NAME(p.schema_id) AS [架构名],p.name AS [存储过程名称],]]></description><category></category></item><item><title><![CDATA[sql表转mysql语句]]></title><link>https://blog.youkuaiyun.com/acycwf/article/details/155101238</link><guid>https://blog.youkuaiyun.com/acycwf/article/details/155101238</guid><author>acycwf</author><pubDate>Fri, 21 Nov 2025 13:38:43 +0800</pubDate><description><![CDATA[sql表转mysql语句]]></description><category></category></item><item><title><![CDATA[记录ubuntu 部署coturn服务 搭建Turn/Stun服务器]]></title><link>https://blog.youkuaiyun.com/acycwf/article/details/144083951</link><guid>https://blog.youkuaiyun.com/acycwf/article/details/144083951</guid><author>acycwf</author><pubDate>Wed, 27 Nov 2024 14:49:37 +0800</pubDate><description><![CDATA[1.安装coturn2.启用coturn,取消注释：TURNSERVER_ENABLED=1目录:/etc/default/coturn3.备份和创建配置文件目录:/etc/turnserver.conf。]]></description><category></category></item><item><title><![CDATA[uni-app利用renderjs+webrtc 实现App音视频通话功能]]></title><link>https://blog.youkuaiyun.com/acycwf/article/details/142497659</link><guid>https://blog.youkuaiyun.com/acycwf/article/details/142497659</guid><author>acycwf</author><pubDate>Fri, 22 Nov 2024 11:27:02 +0800</pubDate><description><![CDATA[【代码】uni-app利用renderjs+webrtc 实现App音视频通话功能。]]></description><category></category></item><item><title><![CDATA[vue2 onlyoffice组件化]]></title><link>https://blog.youkuaiyun.com/acycwf/article/details/143776990</link><guid>https://blog.youkuaiyun.com/acycwf/article/details/143776990</guid><author>acycwf</author><pubDate>Thu, 14 Nov 2024 17:53:15 +0800</pubDate><description><![CDATA[2.在使用的页面调用。]]></description><category></category></item><item><title><![CDATA[.netcore 保存onlyoffice文件]]></title><link>https://blog.youkuaiyun.com/acycwf/article/details/143776942</link><guid>https://blog.youkuaiyun.com/acycwf/article/details/143776942</guid><author>acycwf</author><pubDate>Thu, 14 Nov 2024 17:45:19 +0800</pubDate><description><![CDATA[【代码】.netcore 保存onlyoffice文件。]]></description><category></category></item><item><title><![CDATA[宝塔 docker 部署onlyoffice 服务]]></title><link>https://blog.youkuaiyun.com/acycwf/article/details/143776470</link><guid>https://blog.youkuaiyun.com/acycwf/article/details/143776470</guid><author>acycwf</author><pubDate>Thu, 14 Nov 2024 17:42:24 +0800</pubDate><description><![CDATA[宝塔 docker 部署onlyoffice 服务]]></description><category></category></item><item><title><![CDATA[地图数据链接]]></title><link>https://blog.youkuaiyun.com/acycwf/article/details/124920829</link><guid>https://blog.youkuaiyun.com/acycwf/article/details/124920829</guid><author>acycwf</author><pubDate>Mon, 23 May 2022 09:23:23 +0800</pubDate><description><![CDATA[1.世界数据链接

https://geo.datav.aliyun.com/areas_v3/world_land_boundary.json

2.中国数据链接

https://geo.datav.aliyun.com/areas_v3/bound/100000_full.json

3.数据源获取地址

DataV.GeoAtlas地理小工具系列
]]></description><category></category></item><item><title><![CDATA[sql 循环写法]]></title><link>https://blog.youkuaiyun.com/acycwf/article/details/123680516</link><guid>https://blog.youkuaiyun.com/acycwf/article/details/123680516</guid><author>acycwf</author><pubDate>Wed, 23 Mar 2022 10:56:18 +0800</pubDate><description><![CDATA[1.while 循环


declare @orderNum varchar(255)
create table #ttableName(id int identity(1,1),Orders varchar(255))
declare @n int,@rows int
insert #ttableName(orders) select orderNum from pe_Orders where orderId&lt;50
--select @rows=count(1) from pe_Orders
sel]]></description><category></category></item><item><title><![CDATA[sql行转列]]></title><link>https://blog.youkuaiyun.com/acycwf/article/details/123680114</link><guid>https://blog.youkuaiyun.com/acycwf/article/details/123680114</guid><author>acycwf</author><pubDate>Wed, 23 Mar 2022 10:45:44 +0800</pubDate><description><![CDATA[sql行转列]]></description><category></category></item><item><title><![CDATA[sql server 查询所有表名及注释]]></title><link>https://blog.youkuaiyun.com/acycwf/article/details/121261147</link><guid>https://blog.youkuaiyun.com/acycwf/article/details/121261147</guid><author>acycwf</author><pubDate>Thu, 11 Nov 2021 09:16:21 +0800</pubDate><description><![CDATA[SELECT DISTINCT
 d.name,
 f.value
FROM
 syscolumns a
 LEFT JOIN systypes b ON a.xusertype= b.xusertype
 INNER JOIN sysobjects d ON a.id= d.id
 AND d.xtype= 'U'
 AND d.name&lt;&gt; 'dtproperties'
 LEFT JOIN syscomments e ON a.cdef...]]></description><category></category></item><item><title><![CDATA[sql 查看表字段和注释]]></title><link>https://blog.youkuaiyun.com/acycwf/article/details/120386872</link><guid>https://blog.youkuaiyun.com/acycwf/article/details/120386872</guid><author>acycwf</author><pubDate>Mon, 20 Sep 2021 00:35:30 +0800</pubDate><description><![CDATA[------sqlserver 查询某个表的列名称、说明、备注、类型等SELECT
  表名    = case when a.colorder=1 then d.name else '' end,
  表说明   = case when a.colorder=1 then isnull(f.value,'') else '' end,
  字段序号  = a.colorder,
  字段名   = a.name,
  标识    = case when COLU...]]></description><category></category></item><item><title><![CDATA[sql 查询死锁和消灭死锁]]></title><link>https://blog.youkuaiyun.com/acycwf/article/details/116570799</link><guid>https://blog.youkuaiyun.com/acycwf/article/details/116570799</guid><author>acycwf</author><pubDate>Sun, 09 May 2021 21:16:09 +0800</pubDate><description><![CDATA[select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT'

declare @spid int
Set @spid = 52 --锁表进程
declare @sql varchar(1000)
set @sql='kill '+cast(@spid as varchar)
exec(@sql)
.]]></description><category></category></item><item><title><![CDATA[本地vs添加ip地址访问]]></title><link>https://blog.youkuaiyun.com/acycwf/article/details/115798394</link><guid>https://blog.youkuaiyun.com/acycwf/article/details/115798394</guid><author>acycwf</author><pubDate>Sat, 17 Apr 2021 17:18:17 +0800</pubDate><description><![CDATA[本地vs添加ip地址访问

&lt;sites&gt;

&lt;site&gt;

&lt;bindings&gt;&lt;binding protocol="http" bindingInformation="IP:端口:*" /&gt;

&lt;/bindings&gt;

&lt;/site &gt;

&lt;/sites&gt;
]]></description><category></category></item><item><title><![CDATA[mstsc远程桌面强制登陆]]></title><link>https://blog.youkuaiyun.com/acycwf/article/details/115466282</link><guid>https://blog.youkuaiyun.com/acycwf/article/details/115466282</guid><author>acycwf</author><pubDate>Tue, 06 Apr 2021 17:37:56 +0800</pubDate><description><![CDATA[远程桌面无许可证无法登陆，使用如下命令可强制登陆：

mstsc /v:IP /admin

mstsc /v:IP /console
]]></description><category></category></item><item><title><![CDATA[js 淘宝网页购物车定时操作]]></title><link>https://blog.youkuaiyun.com/acycwf/article/details/114360900</link><guid>https://blog.youkuaiyun.com/acycwf/article/details/114360900</guid><author>acycwf</author><pubDate>Thu, 04 Mar 2021 10:12:40 +0800</pubDate><description><![CDATA[淘宝网页购物车定时操作：1.选中需下单的商品

2.复制代码修改时间


setInterval(function(){var date1=new Date().getTime();var date2=new Date('2021-03-04 10:10:00').getTime();console.log("date1",date1) ;console.log("date2",date2) ; if(date1&gt;=date2){console.log('1');document.getElement]]></description><category></category></item><item><title><![CDATA[uniapp 小程序分享好友和朋友圈]]></title><link>https://blog.youkuaiyun.com/acycwf/article/details/112573287</link><guid>https://blog.youkuaiyun.com/acycwf/article/details/112573287</guid><author>acycwf</author><pubDate>Wed, 13 Jan 2021 16:36:15 +0800</pubDate><description><![CDATA[export default {
	data() {
		return {
			//这个share可以在每个页面的data中设置相应的转发内容
			share: {
				title: '分享有礼',
				path: '/pages/index/index',
			}
		}
	},
	onShareAppMessage(res) {
		var userId = uni.getStorageSync('shareUserId');
		if (userId) this.share.path .]]></description><category></category></item><item><title><![CDATA[通过经纬度计算两点位置的距离]]></title><link>https://blog.youkuaiyun.com/acycwf/article/details/107640442</link><guid>https://blog.youkuaiyun.com/acycwf/article/details/107640442</guid><author>acycwf</author><pubDate>Tue, 28 Jul 2020 17:06:26 +0800</pubDate><description><![CDATA[通过经纬度计算两点位置的距离]]></description><category></category></item><item><title><![CDATA[快递100-获取实时物流信息]]></title><link>https://blog.youkuaiyun.com/acycwf/article/details/107640339</link><guid>https://blog.youkuaiyun.com/acycwf/article/details/107640339</guid><author>acycwf</author><pubDate>Tue, 28 Jul 2020 17:03:26 +0800</pubDate><description><![CDATA[public class ExpressHelper
  {
    /// &lt;summary&gt;
    /// 快递100 获取数据接口
    /// &lt;/summary&gt;
    /// &lt;param name="customer"&gt;快递100分配的的公司编号&lt;/param&gt;
    /// &lt;param name="key"&gt;客户授权key&lt;/param&gt;
    /// ...]]></description><category></category></item><item><title><![CDATA[Senparc 对接公众号消息通知]]></title><link>https://blog.youkuaiyun.com/acycwf/article/details/107252277</link><guid>https://blog.youkuaiyun.com/acycwf/article/details/107252277</guid><author>acycwf</author><pubDate>Fri, 10 Jul 2020 15:43:58 +0800</pubDate><description><![CDATA[Senparc升级后需要使用 DefaultMpMessageContext

/// &lt;summary&gt;
  /// 自定义MessageHandler
  /// 把MessageHandler作为基类，重写对应请求的处理方法
  /// &lt;/summary&gt;
  public partial class CustomMessageHandler : MessageHandler&lt;DefaultMpMessageContext&gt;
  {
 ...]]></description><category></category></item></channel></rss>