34,588
社区成员
发帖
与我相关
我的任务
分享
if object_id('tempdb..#WageTable') is not null
drop table #WageTable
go
create table #WageTable(
[year] varchar(6),
[month] varchar(4),
wagepay int,
bonus1 int,
bonus2 int,
deductions int,
paidin as (wagepay + isnull(bonus1,0) + isnull(bonus2,0) - isnull(deductions,0))
)
insert into #WageTable([year],[month],wagepay,bonus1,bonus2,deductions)
select '2021','02',1000,4000,null,100
select * from #WageTable
查询结果: