-
编辑 删除
SQL Server和Oracle的常用函数对比
---------数学函数1.绝对值S:select abs(-1) valueO:select abs(-1) value from dual2.取整(大)S:select ceiling(-1.001) valueO:select ceil(-1.001) value from dual3.取整（小）S:select floor(-1.001) valueO:select floor(-1.001) value from dual4.取整（截取）S:select cast(-1.002 as int) valueO:select trunc(-1.002) value from dual5.四舍五入S:select round(1.23456,4) value 1.23460O:select round(1.23456,4) value from dual 1.23466.e为底的幂S:select Exp(1) value 2.7182818284590451O:select Exp(1) value from dual
-
编辑 删除
VB 中遍历目录，遍历目录查找文件的2个实现方法
VB 中遍历目录，遍历目录查找文件的2个实现方法方法1：API实现将下列代码保存到一个模块中，就可以直接调用了Public Declare Function FindFirstFile Lib "kernel32" Alias "FindFirstFileA" (ByVal lpFileName As String, lpFindFileData As WIN32_FIND_DATA) As LongPublic Declare Function FindNextFile Lib "kernel32" Alias "FindNextFileA" (ByVal hFindFile As Long, lpFindFileData As WIN32_FIND_DATA) As LongPublic Declare Function FindClose Lib "kernel32" (ByVal hFi
