Friday, 9 March 2007

TSQL: UPDATE from values across server via Linked Server

You'll need to setup a linked server first in Enterprise Manager. This is found under Security > Linked Servers. Right click and select "New Linked Server", follow prompts to complete.


Update Dest
SET helpdefinitiontext = T.helpdefinitiontext
From
[erokwis99\dev].mis.dbo.measure as Dest Join
mis.dbo.measure as T On
Dest.measureid = T.measureid

No comments: