34,594
社区成员
发帖
与我相关
我的任务
分享
truncate table sc.test.dbo.abc
truncate table sc.test.dbo.def
Insert into sc.test.dbo.abc
([bra_num]
,[bra_parent]
,[bra_level]
,[bra_desc]
,[bra_longnum]
,[bra_stat]
,[bra_updatetime]
,[_rowuser])
select [bra_num]
,[bra_parent]
,[bra_level]
,[bra_desc]
,[bra_longnum]
,[bra_stat]
,[bra_updatetime]
,[_rowuser]
from SC2.test.dob.abc
Insert into sc.test.dbo.def select * from SC2.test.dbo.def