<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[dearcylin的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/dearcylin</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; dearcylin]]></copyright><item><title><![CDATA[MSSQL 四舍五入 切舍 切上]]></title><link>https://blog.youkuaiyun.com/dearcylin/article/details/8297239</link><guid>https://blog.youkuaiyun.com/dearcylin/article/details/8297239</guid><author>dearcylin</author><pubDate>Fri, 14 Dec 2012 23:47:06 +0800</pubDate><description><![CDATA[--四舍五入
SELECT CAST(ROUND(50.2,0) AS INT)
--切舍
SELECT FLOOR(50.9)
--切上
SELECT CEILING(50.2)]]></description><category></category></item><item><title><![CDATA[vb.net  c# 转换]]></title><link>https://blog.youkuaiyun.com/dearcylin/article/details/8021244</link><guid>https://blog.youkuaiyun.com/dearcylin/article/details/8021244</guid><author>dearcylin</author><pubDate>Wed, 26 Sep 2012 15:58:58 +0800</pubDate><description><![CDATA[VB.NET、C#変換表
下の表では、VB.NETとC#とで同じ役割を果たしているであろうものをそれぞれを対応させて紹介しています。見やすくするため、分類のようなことをしていますが、これはかなりいい加減です。説明のほとんどはVB.NETの方のMSDNでの説明をのせています。
Visual Basic、Visual J#、C++、C#、JScript、F#の比較は、ヘルプの「各言語の比較」が参考]]></description><category></category></item><item><title><![CDATA[解決EXP-00091的方法]]></title><link>https://blog.youkuaiyun.com/dearcylin/article/details/7307694</link><guid>https://blog.youkuaiyun.com/dearcylin/article/details/7307694</guid><author>dearcylin</author><pubDate>Wed, 29 Feb 2012 20:52:42 +0800</pubDate><description><![CDATA[step 01 查看DB中的NLS_CHARACTERSET的值（提供兩種方法）： 
select * from nls_database_parameters t where 
t.parameter='NLS_CHARACTERSET' 
or 
select * from v$nls_parameters  where 
parameter='NLS_CHARACTERSET';]]></description><category></category></item><item><title><![CDATA[oracle SQL*Plus出力csv]]></title><link>https://blog.youkuaiyun.com/dearcylin/article/details/7307554</link><guid>https://blog.youkuaiyun.com/dearcylin/article/details/7307554</guid><author>dearcylin</author><pubDate>Wed, 29 Feb 2012 20:22:58 +0800</pubDate><description><![CDATA[SQL> desc emp
 名前                            NULL?    タイプ
 ------------------------------- -------- ----
 EMPNO                           NOT NULL NUMBER(4)
 ENAME                                    V]]></description><category></category></item><item><title><![CDATA[从postgre中取出备份表的表名，并且删除30天以前的备份表]]></title><link>https://blog.youkuaiyun.com/dearcylin/article/details/7261835</link><guid>https://blog.youkuaiyun.com/dearcylin/article/details/7261835</guid><author>dearcylin</author><pubDate>Wed, 15 Feb 2012 16:30:15 +0800</pubDate><description><![CDATA[备份表
table_name_20120101
table_name_20120102
table_name_20120103

select relname
from pg_class where relname like 'table_name_20%' and
to_date(substring(replace(relname,'table_name_',''),1,8),'y]]></description><category></category></item><item><title><![CDATA[MSSQL日期函数使用例]]></title><link>https://blog.youkuaiyun.com/dearcylin/article/details/6366131</link><guid>https://blog.youkuaiyun.com/dearcylin/article/details/6366131</guid><author>dearcylin</author><pubDate>Wed, 27 Apr 2011 10:36:00 +0800</pubDate><description><![CDATA[<br /> <br />1. 当前系统日期、时间<br />select getdate()<br /><br />2. dateadd 在向指定日期加上一段时间的基础上，返回新的 datetime 值<br />例如：向日期加上2天<br />select dateadd(day,2,'2004-10-15') --返回：2004-10-17 00:00:00.000<br /> <br />3. datediff 返回跨两个指定日期的日期和时间边界数。<br />select datediff(day]]></description><category></category></item><item><title><![CDATA[CONVERT的用法及取值结果]]></title><link>https://blog.youkuaiyun.com/dearcylin/article/details/6366102</link><guid>https://blog.youkuaiyun.com/dearcylin/article/details/6366102</guid><author>dearcylin</author><pubDate>Wed, 27 Apr 2011 10:26:00 +0800</pubDate><description><![CDATA[CONVERT (data_type[(length)], expression [, style])用法及取值结果SELECT CONVERT(varchar(100), GETDATE(), 0) 07 15 2009 4:06PMSELECT CONVERT(varchar(100), GETDATE(), 1) 07/15/09SELECT CONVERT(varchar(100), GETDATE(), 2) 09.07.15SELECT CONVERT(varchar(100), GETDATE]]></description><category></category></item><item><title><![CDATA[orcle em 端口号忘记 或者em打不开时候的解决方法]]></title><link>https://blog.youkuaiyun.com/dearcylin/article/details/5589576</link><guid>https://blog.youkuaiyun.com/dearcylin/article/details/5589576</guid><author>dearcylin</author><pubDate>Fri, 14 May 2010 10:19:00 +0800</pubDate><description><![CDATA[忘记端口号参照 /oracle/product/10.2.0/db_1/install/portlist.ini em打不开打开cmd   set oracle_sid=orcl      (orcl=设置好的oracle_sid)   emctl start dbconsole 然后打开ie     http：//localhost：端口/em    ]]></description><category></category></item><item><title><![CDATA[嵌入视频播放器代码]]></title><link>https://blog.youkuaiyun.com/dearcylin/article/details/4819898</link><guid>https://blog.youkuaiyun.com/dearcylin/article/details/4819898</guid><author>dearcylin</author><pubDate>Tue, 17 Nov 2009 10:02:00 +0800</pubDate><description><![CDATA[没试过，不知道好不好用页面插入REAL播放器代码：页面插入Media Player播放器代码：页面插入Media Player(视频)播放器代码：             附：1.avi格式代码片断如下：2.mpg格式代码片断如下：3.smi格式代码片断如下：4.rm格式代码片断如下：5.wmv格式代码片断如下：http://activex.microsoft.com/]]></description><category></category></item><item><title><![CDATA[转个FireBird的语句]]></title><link>https://blog.youkuaiyun.com/dearcylin/article/details/4819831</link><guid>https://blog.youkuaiyun.com/dearcylin/article/details/4819831</guid><author>dearcylin</author><pubDate>Tue, 17 Nov 2009 09:53:00 +0800</pubDate><description><![CDATA[ 一、分页写法小例：SELECT FIRST 10 templateid,code,name FROM template ;SELECT FIRST 10 SKIP 10 templateid,code,name FROM template ;SELECT * FROM shop ROWS 1 TO 10;   –firebird2.0支持这种写法二、显示表名和表结构SHOW TABLES]]></description><category></category></item><item><title><![CDATA[Oracle的集合运算符]]></title><link>https://blog.youkuaiyun.com/dearcylin/article/details/4819719</link><guid>https://blog.youkuaiyun.com/dearcylin/article/details/4819719</guid><author>dearcylin</author><pubDate>Tue, 17 Nov 2009 09:42:00 +0800</pubDate><description><![CDATA[表1：temp1AA    BB    CC1      1      11      1      21      1      3表2：temp2AA    BB    CC1      1      11      1      4 1，minusselect aa,bb,cc from temp1minusselect aa,bb,cc from]]></description><category></category></item><item><title><![CDATA[Spread操作------转载]]></title><link>https://blog.youkuaiyun.com/dearcylin/article/details/4312120</link><guid>https://blog.youkuaiyun.com/dearcylin/article/details/4312120</guid><author>dearcylin</author><pubDate>Wed, 01 Jul 2009 10:29:00 +0800</pubDate><description><![CDATA[Imports System.Windows.FormsImports System.DrawingImports FunCommon.IMFunctionImports FunCommonImports FunCommon.CommonFunctionImports FunCommon.AppFunctionPublic Module SpreadFunction    Public pintC]]></description><category></category></item><item><title><![CDATA[SQLServer2008/2005 生成数据字典语句]]></title><link>https://blog.youkuaiyun.com/dearcylin/article/details/4294265</link><guid>https://blog.youkuaiyun.com/dearcylin/article/details/4294265</guid><author>dearcylin</author><pubDate>Wed, 24 Jun 2009 14:05:00 +0800</pubDate><description><![CDATA[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,    ]]></description><category></category></item><item><title><![CDATA[Oracle中--优化SQL语句执行的原则]]></title><link>https://blog.youkuaiyun.com/dearcylin/article/details/4000715</link><guid>https://blog.youkuaiyun.com/dearcylin/article/details/4000715</guid><author>dearcylin</author><pubDate>Wed, 18 Mar 2009 11:07:00 +0800</pubDate><description><![CDATA[ 1。已经检验的语句和已在共享池中的语句之间要完全一样2。变量名称尽量一致3。合理使用外联接4。少用多层嵌套5。多用并发 语句的优化步骤一般有：1。调整sga区，使得sga区的是用最优。2。sql语句本身的优化，工具有explain,sql trace等3。数据库结构调整4。项目结构调整写语句的经验：1。对于大表的查询使用索引2、少用in,exist等3、使用集合运算１．对于大表查询中]]></description><category></category></item><item><title><![CDATA[Oracle的with子句的用法]]></title><link>https://blog.youkuaiyun.com/dearcylin/article/details/3960655</link><guid>https://blog.youkuaiyun.com/dearcylin/article/details/3960655</guid><author>dearcylin</author><pubDate>Thu, 05 Mar 2009 17:57:00 +0800</pubDate><description><![CDATA[用with子句的好处：使用 WITH 子句, 可以避免在SELECT 语句中重复书写相同的语句块WITH 子句将该子句中的语句块执行一次并存储到用户的临时表空间中使用 WITH 子句可以提高查询效率 例子：withtemp_from as (select * from test1),temp_where as (select testid from test2)select * f]]></description><category></category></item><item><title><![CDATA[Oracle的合并语句MERGE INTO 写法小例子 ]]></title><link>https://blog.youkuaiyun.com/dearcylin/article/details/3959692</link><guid>https://blog.youkuaiyun.com/dearcylin/article/details/3959692</guid><author>dearcylin</author><pubDate>Thu, 05 Mar 2009 14:21:00 +0800</pubDate><description><![CDATA[1） 建表DROP TABLE TEST1;DROP TABLE TEST2;CREATE TABLE TEST1(TESTID VARCHAR(5), TEXT VARCHAR(50), FLAG VARCHAR(10));CREATE TABLE TEST2(TESTID VARCHAR(5), TEXT VARCHAR(50), FLAG VARCHAR(10)); ]]></description><category></category></item><item><title><![CDATA[HTML的一些基本知识和技巧]]></title><link>https://blog.youkuaiyun.com/dearcylin/article/details/3957199</link><guid>https://blog.youkuaiyun.com/dearcylin/article/details/3957199</guid><author>dearcylin</author><pubDate>Wed, 04 Mar 2009 17:24:00 +0800</pubDate><description><![CDATA[ HTML中table行数取得document.getElementById(tableID).rows.length 在frame中一个界面通过点击刷新另一个界面parent.frames[frame_name].location.href=url; 在子窗体中点按钮刷新主窗体并关闭if (window.opener != undefined) {    wi]]></description><category></category></item><item><title><![CDATA[半角全角的转换javascript]]></title><link>https://blog.youkuaiyun.com/dearcylin/article/details/3957181</link><guid>https://blog.youkuaiyun.com/dearcylin/article/details/3957181</guid><author>dearcylin</author><pubDate>Wed, 04 Mar 2009 17:21:00 +0800</pubDate><description><![CDATA[ New Document <!--function h(str){var ret=""for(i=0;i<str.length;i++)if(str.charCodeAt(0)>0xff00)ret+=String.fromCharCode(str.charCodeAt(i)-0xfee0)elseret+=String.cha]]></description><category></category></item><item><title><![CDATA[javascript技巧（判断全角,查看字符的asc码,判断是否是数字）]]></title><link>https://blog.youkuaiyun.com/dearcylin/article/details/3957170</link><guid>https://blog.youkuaiyun.com/dearcylin/article/details/3957170</guid><author>dearcylin</author><pubDate>Wed, 04 Mar 2009 17:19:00 +0800</pubDate><description><![CDATA[判断全角escape(text.charAt(i)).charAt(1) 如果上述表达式的值==“u” 为全角查看字符的asc码document.frm.txt.value.charCodeAt(i)判断是否是数字isNan(number) true：不是数字 false：数字]]></description><category></category></item><item><title><![CDATA[html动态显示提示]]></title><link>https://blog.youkuaiyun.com/dearcylin/article/details/3957168</link><guid>https://blog.youkuaiyun.com/dearcylin/article/details/3957168</guid><author>dearcylin</author><pubDate>Wed, 04 Mar 2009 17:19:00 +0800</pubDate><description><![CDATA[B.jsvar moveFlag=false;var fntSize=9;var tipBgColor="FFFFEE";var tipBorderColor="#000000";var tipTextColor="000000";function showTip(msg){    var obj = TipBox;    moveFlag=true;    IE_MouseMove();]]></description><category></category></item></channel></rss>