摘要: 主机ip(192.168.0.1)192.168.0.1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1 )(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = TLPM) ))Oracle数据导入导出imp/exp 功能:Oracle数据导入导出imp/exp就相当与oracle数据还原与备份。大多情况都可以用Oracle数据导入导出完成数据的备份和还原(不会造成数据的丢失)。Oracle有个好处,虽然你的电脑不是服务器,但是你装了ora 阅读全文
posted @ 2012-05-24 16:15 刚仔 阅读(159) 评论(0) 推荐(0)
摘要: sql中这样取,select DateDiff("dd",joindatetime,getdate()) from db那么在c#中呢//C#中使用TimeSpan计算两个时间的差值//可以反加两个日期之间任何一个时间单位。private string DateDiff(DateTime DateTime1, DateTime DateTime2){string dateDiff = null; TimeSpan ts1 = new TimeSpan(DateTime1.Ticks);TimeSpan ts2 = new TimeSpan(DateTime2.Ticks); 阅读全文
posted @ 2012-04-19 19:55 刚仔 阅读(327) 评论(0) 推荐(0)