Database

CREATE TABLE Test1 (
Column1 varchar(50)
);

INSERT INTO Test1 (Column1)
VALUES ('ABC');

CREATE TABLE Test2 (
Column2 varchar(50)
);

UPDATE Test1
SET Test1.Column1 = Test2.Column2
FROM Test2

UPDATE Test1
SET Test1.Column1 = a.Column2
FROM Test2 a
INNER JOIN Test2 b
ON a.Column2 = b.Column2

UPDATE MyTable
SET p.Column1 = (SELECT pm.Column1
                 FROM Property p
                 inner join Address a
                 on p.PropertyRef = a.PropertyRef
                 inner join remotedb.PropertyMaster pm
                 on pm.PropertyRef = p.PropertyRef)

Ashfield wrote:

This is the 3rd time you have asked the question, the answer is NOT going to change!!!!!

INSERT INTO commentdetail
(commentDetailID, commentID, commentType, locator1, locator2)
VALUES (?commentDetailID, ?commentID, ?commentType, ?locator1, ?locator2)

Header||
xx|yy|zz
aa|bb|cc
Footer||

EXEC sp_configure 'show advanced options', 1 -- enable advanced options
RECONFIGURE                                  -- apply the new setting
sp_configure                                 -- list all configuration options and their values

EXEC sp_configure 'query governor cost limit', 1000000 -- either modify the value
EXEC sp_configure 'query governor cost limit', 0       -- or disable query governor
RECONFIGURE                                            -- apply the new setting