SQL Server有没有类似POSTGRE数据库的下面用法:
WITH typeTeiki_TUKIN_IC(sortNum, val, nm) AS
(
VALUES(CAST(3 AS NUMERIC), CAST('020131' AS VARCHAR), CAST('aaaa' AS VARCHAR))
, (CAST(3 AS NUMERIC), CAST('020132' AS VARCHAR), CAST('bbbbb' AS VARCHAR))
)
SELECT * FROM typeTeiki_TUKIN_IC
这里用WITH整了一个虚拟表出来。
SQL Server有没有类似的功能?
SQL Server有WITH 但是不支持 VALUES
有没有知道的?我在网上没查到相关资料!
------解决方案--------------------
SQL Server这样写:
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
*/