iteye_20852的博客

1. MSSQL:field: 默认nullable, primate key 被指定"NOT NULL".不可以用"DROP TABLE IF EXISTS".2. 通用SQL函数连接函数： CONCAT(FIRST_NAME,' ',LAST_NAME) AS FULL_NAME

Foreword: TBL_BPM_HK_PINS save house keep process instances(contains all outdated pins and uptodate pins), TBL_BPM_PMAP save process maps. Maybe the process map has been deleted, so if want to provide...

[color=blue]1.SET DEFINE OFF 的用法;[/color](摘自：http://hi.baidu.com/wanghp/blog/item/50d8a901fa57e4061d9583c6.html)在SQL*Plus中默认的"&"表示替代变量，也就是说，只要在命令中出现该符号，SQL*Plus就会要你输入替代值。这就意味着你无法将一个含有该符号的字符串输入数据库或...

[color=blue]1. sql区别以及对应关系。[/color]mysql oracle DB2 sqlserver DerbyXXXXX blob XXXXX image XXXXXXXXXX clob XXXXX text XXXXXdate ...

1. CHARINDEX vs INSTR[code="java"]if ("MSSQL".equals(DATABASE_TYPE)) { express = " CHARINDEX(bas.COLUMN_ID,col.expression) ";} else { express = " INSTR(col.expression, bas.COLUMN_ID) ";...

1、MySQL数据库 Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //or com.mysql.jdbc.DriverString url ="jdbc:mysql://localhost/myDB?user=soft&password=soft1234&useUnicode=true&characterEncodin...