<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[invisableway的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/invisableway</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; invisableway]]></copyright><item><title><![CDATA[[引用]Android通过百度地图API用Service和Alarm在后台定时获取地理位置信息 ]]></title><link>https://blog.youkuaiyun.com/invisableway/article/details/84771995</link><guid>https://blog.youkuaiyun.com/invisableway/article/details/84771995</guid><author>invisableway</author><pubDate>Mon, 21 Mar 2016 13:51:52 +0800</pubDate><description><![CDATA[
转自 http://www.cnblogs.com/wangfenjin/archive/2013/01/09/2853307.html
Android通过百度地图API用Service和Alarm在后台定时获取地理位置信息
 


本文主要介绍了Android项目集成百度地图API，使用AlarmManager定时调用Service，在Service中请求坐标更新，并通过坐标得到省、...]]></description><category></category></item><item><title><![CDATA[动态引用Webservice]]></title><link>https://blog.youkuaiyun.com/invisableway/article/details/84684112</link><guid>https://blog.youkuaiyun.com/invisableway/article/details/84684112</guid><author>invisableway</author><pubDate>Thu, 06 Nov 2014 14:48:43 +0800</pubDate><description><![CDATA[
 
Imports System.Collections.Generic
Imports System.Text
Imports System.IO
Imports System.Configuration
Imports System.CodeDom
Imports System.CodeDom.Compiler
Imports System.Net
Imports Syste...]]></description><category></category></item><item><title><![CDATA[Oracle 存储过程中执行动态合成SQL语句输出多条记录]]></title><link>https://blog.youkuaiyun.com/invisableway/article/details/84662955</link><guid>https://blog.youkuaiyun.com/invisableway/article/details/84662955</guid><author>invisableway</author><pubDate>Mon, 13 Oct 2014 17:30:03 +0800</pubDate><description><![CDATA[
CREATE OR REPLACE 
PROCEDURE ~~~~~~~~--（过程名称）

(
  v_id IN NUMBER ,
  v_cid IN NUMBER ,
	cv_1 Out Sys_RefCursor  --声明游标
)
AS
   v_SQL VARCHAR2(4000);
   v_FName VARCHAR2(50);
   v_FField ...]]></description><category></category></item><item><title><![CDATA[SQLSERVER2005移植到Oracle 11g]]></title><link>https://blog.youkuaiyun.com/invisableway/article/details/84661352</link><guid>https://blog.youkuaiyun.com/invisableway/article/details/84661352</guid><author>invisableway</author><pubDate>Thu, 09 Oct 2014 17:56:42 +0800</pubDate><description><![CDATA[
使用ORACLE SQL DEVELOPER
1、从官网下载一个比较老的版本3.0.04的版本
 
2、从SourceForge下载JTDS.jar加入到ORACLE SQL DEVELOPER

 
点确定后在连接中出现了SQLSERVER 和Sybase的连接选项

 
连接SQLServer2005其它实例，要在端口中输入对应实例的端口号！
 
然后在SQLSERV...]]></description><category></category></item><item><title><![CDATA[win 8.1 装sqlserver 2005 无法启动错误]]></title><link>https://blog.youkuaiyun.com/invisableway/article/details/84537577</link><guid>https://blog.youkuaiyun.com/invisableway/article/details/84537577</guid><author>invisableway</author><pubDate>Sat, 15 Mar 2014 16:35:35 +0800</pubDate><description><![CDATA[
原文：http://www.win8china.com/html/6732.html
 
在Win8.1系统下如何安装运行SQL Server 2005
按正常情况，在Win8/Win8.1系统下安装微软的SQL Server 2005套件会存在兼容问题，即使安装完，最后的结果就是导致其服务项无法正常启动。
如果用户创建使用的项目非要按照SQL Server 2005的标准进行运行和调试...]]></description><category></category></item><item><title><![CDATA[SQL FOR XML PATH 合成字符串 关联表]]></title><link>https://blog.youkuaiyun.com/invisableway/article/details/84534735</link><guid>https://blog.youkuaiyun.com/invisableway/article/details/84534735</guid><author>invisableway</author><pubDate>Fri, 07 Mar 2014 09:28:33 +0800</pubDate><description><![CDATA[
declare @t table (Id int, Value char(5))
insert into @t
select '1','09:01' union
select '1','12:05' union
select '2','08:04' union
select '2','17:09' union
select '3','99888'

select * from @...]]></description><category></category></item><item><title><![CDATA[SQL ROW_NUMBER() OVER]]></title><link>https://blog.youkuaiyun.com/invisableway/article/details/84444993</link><guid>https://blog.youkuaiyun.com/invisableway/article/details/84444993</guid><author>invisableway</author><pubDate>Thu, 20 Jun 2013 11:52:01 +0800</pubDate><description><![CDATA[

原文地址：http://www.cnblogs.com/fatbird/p/Sql-Remove-duplicate.html

Row_Number() over()
over()里面有两个参数
Partition by value_expression
将 FROM 子句生成的结果集划入应用了 ROW_NUMBER 函数的分区。 value_expression 指定对结果集进行...]]></description><category></category></item></channel></rss>