22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT
CustomerName AS UserName,
CompanyTel AS UserTel,
MoveTel AS Mobile,
PostalCode AS PostCode,
Email,
Address,
(CASE WHEN State='已经发邮件' then 'true' else 'false' end )AS Flags,
date AS DoDate
FROM [tjhuangjin].[dbo].Simulate
INSERT [OneToFive].[dbo].[SimulationUser]
(
UserName,
UserTel,
Mobile,
PostCode,
Email,
Address,
Flags,
DoDate
)
SELECT
CustomerName AS UserName,
CompanyTel AS UserTel,
MoveTel AS Mobile,
PostalCode AS PostCode,
Email,
Address,
CASE
WHEN(State='已经发邮件')then 'true' else 'false' end ,
date AS DoDate
FROM [tjhuangjin].[dbo].Simulate
--try
USE OneToFive
go
INSERT SimulationUser
(
UserName,
UserTel,
Mobile,
PostCode,
Email,
Address,
Flags,
DoDate
)
go
USE tjhuangjin
go
SELECT
CustomerName AS UserName,
CompanyTel AS UserTel,
MoveTel AS Mobile,
PostalCode AS PostCode,
Email,
Address,
CASE
WHEN(State='已经发邮件')then 'true' else 'false' end ,
date AS DoDate
FROM
Simulate
insert into 数据库1名..表名(字段名) select 字段 from 数据库2名..表名