一、不同版本数据库小结
1、oracle数据库拼接、截取如下:
SELECT substr (cqzsbh, 3),cqzsbh FROM djf_dj_fz
WHERE cqzsbh LIKE #{ notype }|| '%'
AND substr (cqzsbh, 3) >=#{ startno }
AND substr (cqzsbh, 3) <=#{ endno }
2、sqlserver数据库拼接、截取如下:
SELECT COUNT (*) FROM sde.djf_dj_fz
WHERE cqzsbh LIKE #{ notype } + '%'
AND SUBSTRING (cqzsbh, 4, 9) >=#{ startno }
AND SUBSTRING (cqzsbh, 4, 9) <=#{ endno }