可以把结果集倒入到临时表中,再查询.如:
SELECT id_num = IDENTITY(int, 1, 1), JSZJE, JSBZ, (JSZJE-JSBZ) AS WJSJE INTO #jiesuan FROM table_name [ WHERE 条件 ]
GO
SELECT * FROM #jiesuan
SELECT id_num = IDENTITY(int, 1, 1), JSZJE, JSBZ, (JSZJE-JSBZ) AS WJSJE INTO #jiesuan FROM table_name [ WHERE 条件 ]
GO
SELECT * FROM #jiesuan
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货