廣告：

INSERT INTO eaddress
(userid, ename, company, part,email,adddate)
SELECT 'zhangpei' AS Expr1, 聯系人,公司名, 部門,郵箱,GETDATE() AS Expr2
FROM zhangpei.dbo.Sheet1$ where 郵箱 is not null and 郵箱<>''

INSERT INTO eaddress
(userid, ename, company, part, email,adddate)
SELECT 'liaohuayan' AS Expr1, 聯系人, 公司名, 部門, 公司郵箱地址,GETDATE() AS Expr2
FROM liaohuayan.dbo.Sheet1$ where 公司郵箱地址 is not null and 公司郵箱地址<>''

廣告：