SELECT * into 费用表7 from 费用表 where 1=0
UPDATE TOP(1) 费用表
SET 金额 = 1
OUTPUT INSERTED.*
INTO 费用表7
FROM 费用表
WHERE 生成工号 = 99999
转载于:https://www.cnblogs.com/qanholas/archive/2011/08/09/2132369.html
SELECT * into 费用表7 from 费用表 where 1=0
UPDATE TOP(1) 费用表
SET 金额 = 1
OUTPUT INSERTED.*
INTO 费用表7
FROM 费用表
WHERE 生成工号 = 99999
转载于:https://www.cnblogs.com/qanholas/archive/2011/08/09/2132369.html