日期:2014-05-16 浏览次数:20678 次
WITH typeTeiki_TUKIN_IC(sortNum, val, nm) AS
(
SELECT CAST(3 AS NUMERIC), CAST('020131' AS VARCHAR), CAST('aaaa' AS VARCHAR)
UNION ALL
SELECT CAST(3 AS NUMERIC), CAST('020132' AS VARCHAR), CAST('bbbbb' AS VARCHAR)
)
SELECT * FROM typeTeiki_TUKIN_IC
/*
sortNum val nm
--------------------------------------- ------------------------------ ------------------------------
3 020131 aaaa
3 020132 bbbbb
*/