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 Derby XXXXX blob XXXXX image XXXXX XXXXX clob XXXXX text XXXXX date ...

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.Driver String url ="jdbc:mysql://localhost/myDB?user=soft&password=soft1234&useUnicode=true&characterEncodin...