34,588
社区成员
发帖
与我相关
我的任务
分享
UPDATE [Product] SET [Data_No] = access_product.[Data_No], R1 = access_product.R1, R2 = access_product.R2,
R3 = access_product.R3, R4 = access_product.R4, R5 = access_product.R5, R6 = access_product.R6,
B1 = access_product.B1
FROM Lottery sql_product RIGHT JOIN OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'D:\Work\DataBase\Product.mdb';'admin';'',[Lottery]) access_product
ON sql_product.[Data_No] = access_product.[Data_No]
WHERE sql_product.[Data_No] IS NULL
SELECT access_product.[Data_No], access_product.[R1], access_product.[R2], access_product.[R3],
access_product.[R4], access_product.[R5], access_product.[R6], access_product.[B1],
sql_product.[Data_No], sql_product.[R1], sql_product.[R2], sql_product.[R3],
sql_product.[R4], sql_product.[R5], sql_product.[R6], sql_product.[B1]
FROM product sql_product RIGHT JOIN OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'D:\Work\DataBase\product.mdb';'admin';'',[product]) access_product
ON sql_product.[Data_No] = access_product.[Data_No]
WHERE sql_product.[Data_No] IS NULL
SELECT access_product.[Data_No], access_product.[R1], access_product.[R2], access_product.[R3],
access_product.[R4], access_product.[R5], access_product.[R6], access_product.[B1],
sql_product.[Data_No], sql_product.[R1], sql_product.[R2], sql_product.[R3],
sql_product.[R4], sql_product.[R5], sql_product.[R6], sql_product.[B1]
FROM product sql_product RIGHT JOIN OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'D:\Work\DataBase\product.mdb';'admin';'',[product]) access_product
ON sql_product.[Data_No] = access_product.[Data_No]
WHERE sql_product.[Data_No] IS NULL
select
access_product.[Data_No], R1 = access_product.R1, R2 = access_product.R2,
R3 = access_product.R3, R4 = access_product.R4, R5 = access_product.R5, R6 = access_product.R6,
B1 = access_product.B1
FROM Lottery sql_product RIGHT JOIN OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'D:\Work\DataBase\Product.mdb';'admin';'',[Lottery]) access_product
ON sql_product.[Data_No] = access_product.[Data_No]
WHERE sql_product.[Data_No] IS NULL
這樣有數據嗎?
UPDATE sql_product SET [Data_No] = access_product.[Data_No], R1 = access_product.R1, R2 = access_product.R2,
R3 = access_product.R3, R4 = access_product.R4, R5 = access_product.R5, R6 = access_product.R6,
B1 = access_product.B1
FROM Lottery sql_product RIGHT JOIN OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'D:\Work\DataBase\Product.mdb';'admin';'',[Lottery]) access_product
ON sql_product.[Data_No] = access_product.[Data_No]
WHERE sql_product.[Data_No] IS NULL
------------------- try
UPDATE access_product SET [Data_No] = access_product.[Data_No], R1 = access_product.R1, R2 = access_product.R2,
R3 = access_product.R3, R4 = access_product.R4, R5 = access_product.R5, R6 = access_product.R6,
B1 = access_product.B1
FROM Lottery sql_product RIGHT JOIN OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'D:\Work\DataBase\Product.mdb';'admin';'',[Lottery]) access_product
ON sql_product.[Data_No] = access_product.[Data_No]
WHERE sql_product.[Data_No] IS NULL
UPDATE [sql_Product] SET ...??
UPDATE [Product] SET [Data_No] = access_product.[Data_No], R1 = access_product.R1, R2 = access_product.R2,
R3 = access_product.R3, R4 = access_product.R4, R5 = access_product.R5, R6 = access_product.R6,
B1 = access_product.B1
FROM Lottery sql_product RIGHT JOIN OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'D:\Work\DataBase\Product.mdb';'admin';'',[/*Lottery把这个改成后面这个呢?*/product]) access_product
ON sql_product.[Data_No] = access_product.[Data_No]
WHERE sql_product.[Data_No] IS NULL