--将A数据库的两张表复制到B库去
--方法一:
insert into B.dbo.T_sWebPurviewManager(UserName,WebWinInfoName)
select UserName,WebWinInfoName from A.dbo.T_sWebPurviewManager
--方法二:
select * into B.dbo.T_sWebWinInfo from A.dbo.T_sWebWinInfo
--方法一:
insert into B.dbo.T_sWebPurviewManager(UserName,WebWinInfoName)
select UserName,WebWinInfoName from A.dbo.T_sWebPurviewManager
--方法二:
select * into B.dbo.T_sWebWinInfo from A.dbo.T_sWebWinInfo