字段連接的各种數据庫的寫法

字段連接的各种數据庫的寫法

以下簡單介紹字段連接的各种數据庫的寫法

db2

select dpt_no||dpt_nam from db2admin.bsdptms

select dpt_no CONCAT dpt_nam from db2admin.bsdptms

oracle

select dpt_no||dpt_nam from db2admin.bsdptms

select concat(dpt_no,dpt_nam) from db2admin.bsdptms

informix

select dpt_no||dpt_nam from db2admin.bsdptms

sybase

select dpt_no||dpt_nam from db2admin.bsdptms

access

select dpt_no+dpt_nam from db2admin.bsdptms

foxpro

select dpt_no+dpt_nam from db2admin.bsdptms

SQLSERVER

select dpt_no||dpt_nam from db2admin.bsdptms