DELETE FROM db_fb WHERE fb_id='FB0000000810127' INSERT INTO dbo.db_fb SELECT * FROM XZCD.fbbook.dbo.db_fb WHERE fb_id='FB0000000810127'如上述语句,我之前都是用Insert Into 但是都必须要先Delete那行才能插入,我现在不想删除那行,有没有什么Update语句可以全部更新。不用一列一列的去Set
DELETE FROM db_fb WHERE fb_id='FB0000000810127' INSERT INTO dbo.db_fb SELECT * FROM XZCD.fbbook.dbo.db_fb WHERE fb_id='FB0000000810127' update dbo.db_fb set 字段1 = XZCD.fbbook.dbo.db_fb.字段1 --等其他列 from XZCD.fbbook.dbo.db_fb where db_fb.fb_id = XZCD.fbbook.dbo.db_fb.fb_id
这个语法尚待开发。
INSERT INTO dbo.db_fb SELECT * FROM XZCD.fbbook.dbo.db_fb WHERE fb_id='FB0000000810127' update dbo.db_fb
set 字段1 = XZCD.fbbook.dbo.db_fb.字段1
--等其他列
from XZCD.fbbook.dbo.db_fb where db_fb.fb_id = XZCD.fbbook.dbo.db_fb.fb_id