创建数据表
CREATE TABLE [dbo].[ks](
[id] [int] IDENTITY(1,1) NOT NULL,[kucun] [varchar](50) NULL,
[kuncunshu] [int] NULL,
[states] [bit] NULL
)
states默认值设置为0
数据库数据:
1 A 1 false
2 A 2 false
3 B 3 false
4 A 4 false
要求数据库结果:
5 A 7 true
6 B 3 true
SQL语句:
update ks set states=1 where states=0
go
insert into ks (kucun,kuncunshu)
SELECT kucun, SUM(kuncunshu)
FROM ks
GROUP BY kucun
go
delete from ks where states=1
go
update ks set states=1
go
select * from ks