所有用法 insert into tb() values() insert into tb select .. union all select .. insert into tb select .. from newtb where .......update tb set c1 = ..,c2 = ..update a set a.c1 = a.c1 + b.c2 from tb a,newtb b where a.id = b.id and ........ delete from tb delete from tb where ... delete t from tb t,newtb c where t.id = c.id and ....... --去看看联机丛书!
直接看联机丛书 按F1就有了insert into....select .....
insert top(x) * into update top(x) delete top(x) from
insert into tb() values()
insert into tb select .. union all select ..
insert into tb select .. from newtb where .......update tb
set c1 = ..,c2 = ..update a
set a.c1 = a.c1 + b.c2
from tb a,newtb b
where a.id = b.id and ........
delete from tb
delete from tb where ...
delete t from tb t,newtb c where t.id = c.id and .......
--去看看联机丛书!
按F1就有了insert into....select .....
update top(x)
delete top(x) from