<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[中国风]]></title><description><![CDATA[激情在燃烧!!!]]></description><link>https://blog.csdn.net/roy_88</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; roy_88]]></copyright><item><title><![CDATA[格式化拆分栏位]]></title><link>https://blog.csdn.net/roy_88/article/details/108734967</link><guid>https://blog.csdn.net/roy_88/article/details/108734967</guid><author>roy_88</author><pubDate>Tue, 22 Sep 2020 16:25:31 +0800</pubDate><description><![CDATA[use Tempdb
go
--&gt; --&gt; 中国风(Roy)生成測試數據
 
if not object_id(N'Sheet1') is null
	drop table Sheet1
Go
Create table Sheet1([授课教师] nvarchar(179))
Insert Sheet1
select N'叶宏[112017],李广军[112123]' union all
select N'韩翔2[004041]' union all
select N'张文[334104],丁.]]></description><category></category></item><item><title><![CDATA[SQL SERVER 实现计算距离方法]]></title><link>https://blog.csdn.net/roy_88/article/details/79744690</link><guid>https://blog.csdn.net/roy_88/article/details/79744690</guid><author>roy_88</author><pubDate>Thu, 29 Mar 2018 16:19:44 +0800</pubDate><description><![CDATA[SQL2008以上的版本支持：注意，在计算过程中要处理好数据，如：经纬度不能有NULL会报错，有0会计算不正确,这类最好过滤，在现实应用中可借用计算列简化语句e.g.use Tempdb
go
--&amp;gt; --&amp;gt; 中国风(Roy)生成測試數據
 
if not object_id(N'Tempdb..#Destn') is null
	drop table #Destn
Go
Create...]]></description><category></category></item><item><title><![CDATA[不同版本SQL SERVER备份还原时造成索引被禁用]]></title><link>https://blog.csdn.net/roy_88/article/details/50150231</link><guid>https://blog.csdn.net/roy_88/article/details/50150231</guid><author>roy_88</author><pubDate>Sat, 03 Mar 2018 17:49:08 +0800</pubDate><description><![CDATA[以下测试例子以SQL 2008备份，在SQL2014还原,造成索引被禁用.--备份环境（SQL Server 2008 R2）/*MicrosoftSQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)          Apr 2 2010 15:48:46          Copyright (c) Microsoft Corporation       ...]]></description><category></category></item><item><title><![CDATA[COPY到目标源（EXCEL或WPS)丢失记录BUG及解决方法]]></title><link>https://blog.csdn.net/roy_88/article/details/76229053</link><guid>https://blog.csdn.net/roy_88/article/details/76229053</guid><author>roy_88</author><pubDate>Fri, 28 Jul 2017 10:12:47 +0800</pubDate><description><![CDATA[COPY到目标源（EXCEL或WPS)丢失记录BUG及解决方法]]></description><category></category></item><item><title><![CDATA[SQL SERVER【非域环境】镜像之搭建篇]]></title><link>https://blog.csdn.net/roy_88/article/details/72833180</link><guid>https://blog.csdn.net/roy_88/article/details/72833180</guid><author>roy_88</author><pubDate>Thu, 01 Jun 2017 17:22:59 +0800</pubDate><description><![CDATA[SQL SERVER 2014 镜像 搭建，操作步骤同旧版本没有区别]]></description><category></category></item><item><title><![CDATA[SQL SERVER【非域环境】同步复制（对等）之搭建篇]]></title><link>https://blog.csdn.net/roy_88/article/details/71082991</link><guid>https://blog.csdn.net/roy_88/article/details/71082991</guid><author>roy_88</author><pubDate>Tue, 02 May 2017 17:00:21 +0800</pubDate><description><![CDATA[SQL Server 2014 同步复制（对等）]]></description><category></category></item><item><title><![CDATA[SQL SERVER【非域环境】同步复制（合并）之搭建篇]]></title><link>https://blog.csdn.net/roy_88/article/details/70802853</link><guid>https://blog.csdn.net/roy_88/article/details/70802853</guid><author>roy_88</author><pubDate>Wed, 26 Apr 2017 16:13:43 +0800</pubDate><description><![CDATA[SQL Server 2014 合并事务搭建]]></description><category></category></item><item><title><![CDATA[SQL SERVER【非域环境】同步复制（事务）之搭建篇(2)]]></title><link>https://blog.csdn.net/roy_88/article/details/70332108</link><guid>https://blog.csdn.net/roy_88/article/details/70332108</guid><author>roy_88</author><pubDate>Fri, 21 Apr 2017 17:10:03 +0800</pubDate><description><![CDATA[SQL SERVER2014 同步复制--事务]]></description><category></category></item><item><title><![CDATA[SQL SERVER【非域环境】同步复制（事务）之准备篇(1)]]></title><link>https://blog.csdn.net/roy_88/article/details/70316525</link><guid>https://blog.csdn.net/roy_88/article/details/70316525</guid><author>roy_88</author><pubDate>Fri, 21 Apr 2017 16:50:22 +0800</pubDate><description><![CDATA[SQL SERVER2014同步复制--事务]]></description><category></category></item><item><title><![CDATA[搭建Hadoop2.7.3+Hive2.1.1及MySQL(配置Hive+MySQL+Connector）(三)]]></title><link>https://blog.csdn.net/roy_88/article/details/60884980</link><guid>https://blog.csdn.net/roy_88/article/details/60884980</guid><author>roy_88</author><pubDate>Wed, 08 Mar 2017 23:35:54 +0800</pubDate><description><![CDATA[搭建Hadoop2.7.3+Hive2.1.1及MySQL(配置Hive）
Hive配置MySQL,配置常见问题。]]></description><category></category></item><item><title><![CDATA[搭建Hadoop2.7.3+Hive2.1.1及MySQL(配置Hive+Hadoop）(二)]]></title><link>https://blog.csdn.net/roy_88/article/details/54948154</link><guid>https://blog.csdn.net/roy_88/article/details/54948154</guid><author>roy_88</author><pubDate>Thu, 09 Feb 2017 16:02:40 +0800</pubDate><description><![CDATA[搭建Hadoop2.7.3+Hive2.1.1及MySQL]]></description><category></category></item><item><title><![CDATA[搭建Hadoop2.7.3+Hive2.1.1及MySQL(配置Hadoop）(一)]]></title><link>https://blog.csdn.net/roy_88/article/details/54944672</link><guid>https://blog.csdn.net/roy_88/article/details/54944672</guid><author>roy_88</author><pubDate>Thu, 09 Feb 2017 11:14:02 +0800</pubDate><description><![CDATA[搭建Hadoop2.7.3+Hive2.1.1及MySQL]]></description><category></category></item><item><title><![CDATA[Linux(CentOS)环境下安装MySQL]]></title><link>https://blog.csdn.net/roy_88/article/details/54883475</link><guid>https://blog.csdn.net/roy_88/article/details/54883475</guid><author>roy_88</author><pubDate>Sun, 05 Feb 2017 22:04:03 +0800</pubDate><description><![CDATA[Linux(CentOS)环境下安装MySQL]]></description><category></category></item><item><title><![CDATA[Linux(CentOS)环境下安装SQL SERVER]]></title><link>https://blog.csdn.net/roy_88/article/details/54602009</link><guid>https://blog.csdn.net/roy_88/article/details/54602009</guid><author>roy_88</author><pubDate>Wed, 18 Jan 2017 16:42:54 +0800</pubDate><description><![CDATA[一、准备工作1、首先安装CentOS系统版本下载地址1下载地址2可在以上网址查最新版本2、本机需要连接互联网(后面实例是以在线安装为例），在线安装便洁，也会提到离线安装直接下载安装包.二、安装SQL SERVER（以root用户账号安装）1、下载Microsoft Red Hat存储库配置文件。[root@localhost Desktop]# curl https://packages.micr]]></description><category></category></item><item><title><![CDATA[Sqlcmd导入数据脚本乱码解决方法]]></title><link>https://blog.csdn.net/roy_88/article/details/52595854</link><guid>https://blog.csdn.net/roy_88/article/details/52595854</guid><author>roy_88</author><pubDate>Tue, 20 Sep 2016 15:24:29 +0800</pubDate><description><![CDATA[在SQL SERVER环境，Sqlcmd导入数据脚本乱码解决方法]]></description><category></category></item><item><title><![CDATA[MySQL用户变量-预处理语句(动态语句用法)]]></title><link>https://blog.csdn.net/roy_88/article/details/52136120</link><guid>https://blog.csdn.net/roy_88/article/details/52136120</guid><author>roy_88</author><pubDate>Sat, 06 Aug 2016 15:04:20 +0800</pubDate><description><![CDATA[MySQL用户变量-预处理语句(动态语句用法)]]></description><category></category></item><item><title><![CDATA[SQL Server开发接口生成方法]]></title><link>https://blog.csdn.net/roy_88/article/details/51331261</link><guid>https://blog.csdn.net/roy_88/article/details/51331261</guid><author>roy_88</author><pubDate>Fri, 06 May 2016 14:13:48 +0800</pubDate><description><![CDATA[为提高开发效率，生成固定格式的接口是必须的，以下以提供新增/修改/删除/读取接口为例：
以常见的表结构为例，特殊表结构可自己尝试去调整方法]]></description><category></category></item><item><title><![CDATA[网上论坛生成测试数据方法（抢分利器）]]></title><link>https://blog.csdn.net/roy_88/article/details/51329170</link><guid>https://blog.csdn.net/roy_88/article/details/51329170</guid><author>roy_88</author><pubDate>Fri, 06 May 2016 10:03:27 +0800</pubDate><description><![CDATA[网上论坛生成测试数据方法（抢分利器）]]></description><category></category></item><item><title><![CDATA[C#调用SQL Server分页存储过程]]></title><link>https://blog.csdn.net/roy_88/article/details/51318650</link><guid>https://blog.csdn.net/roy_88/article/details/51318650</guid><author>roy_88</author><pubDate>Wed, 04 May 2016 22:26:42 +0800</pubDate><description><![CDATA[C#调用SQL Server分页存储过程]]></description><category></category></item><item><title><![CDATA[SQL Server 用链接服务器 同步MySQL]]></title><link>https://blog.csdn.net/roy_88/article/details/50982979</link><guid>https://blog.csdn.net/roy_88/article/details/50982979</guid><author>roy_88</author><pubDate>Fri, 25 Mar 2016 18:06:36 +0800</pubDate><description><![CDATA[SQL Server 用链接服务器 同步MySql]]></description><category></category></item></channel></rss>