34,593
社区成员
发帖
与我相关
我的任务
分享
create table tb(a int , b int ,c as a + b)
go
insert into tb(a , b) values(1,1)
insert into tb(a , b) values(2,1)
insert into tb(a , b) values(3,1)
insert into tb(a , b) values(1,6)
insert into tb(a , b) values(1,9)
select * from tb
drop table tb
/*
a b c
----------- ----------- -----------
1 1 2
2 1 3
3 1 4
1 6 7
1 9 10
(所影响的行数为 5 行)
*/
create table #(id int, data as id*100)
insert # select 1
select * from #
1 100