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
服务器: 消息 7202,级别 11,状态 2,行 1
在 sysservers 中未能找到服务器 'Lottery'。请执行 sp_addlinkedserver 以将服务器添加到 sysservers。如果改成如下,就是对的,真不明白了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
这怎么比较
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
在 sysservers 中未能找到服务器 'product'。请执行 sp_addlinkedserver 以将服务器添加到 sysservers。
------------------- 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
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不明白你要更新那個表
但是我不明白的是,在不添加链接服务器,也能在SQL查询分析器用SELECT查询access数据,同样用UPDATE怎么就不可以了呢....?
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這樣有數據嗎?
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这样是有数据啊,所以我就觉得奇怪!!
(所影响的行数为 0 行)
http://topic.csdn.net/u/20090617/11/ad341e32-1fa0-45fa-a42e-dcd4821c20df.html?735
继续帮帮我,谢谢!~!