sql表 gzk 结构:
gh_xx ff
001 50
002 30
001 60
002 40
002 30
003 10
... ...
select gh_xx,sum(ff) from gzk group by gh_xx
我想要把这个查询结果替换原表,就是新表的名字还是gzk,用代码怎么实现??
gh_xx ff
001 50
002 30
001 60
002 40
002 30
003 10
... ...
select gh_xx,sum(ff) from gzk group by gh_xx
我想要把这个查询结果替换原表,就是新表的名字还是gzk,用代码怎么实现??
into #gzk
from gzk group by gh_xxdelete from gzk
insert gzk select * from #gzkdrop table #gzk
into #gzk
from gzk group by gh_xxtruncate table gzk
insert gzk select * from #gzkdrop table #gzk
set ff = (select sum(ff) from gzk where gh_xx = t.gh_xx)
from gzk t