SELECT *
FROM   testA
       JOIN testB b
            ON  testA.id = b.id
WHERE  id = 2

SELECT *
FROM test a
WHERE a.id = (SELECT id FROM test WHERE id = a.id) ;

SELECT *
FROM test a
WHERE a.id = (SELECT test.id FROM test WHERE test.id = a.id) ;

SELECT *
FROM test a
WHERE a.id = (SELECT b.id FROM test b WHERE b.id = a.id) ;

SELECT *
FROM   testA
WHERE   id=2

UPDATE testA a
SET    a.[Content] = b.Content
FROM   testB b
WHERE  a.PageID = b.pageID
       AND a.PageID = 2

UPDATE Dest
SET    [Content] = a.Content
FROM   EServices_Pages_Content Dest
INNER JOIN [dstrn].weberp.dbo.EServices_Pages_Content a
    ON Dest.PageID = a.pageID
    ...
WHERE a.PageID =2

 <update statement: positioned> ::=
              UPDATE <table name>
                SET <set clause list>
                  WHERE CURRENT OF <cursor name>

         <set clause list> ::=
              <set clause> [ { <comma> <set clause> }... ]

         <set clause> ::=
              <object column> <equals operator> <update source>

         <update source> ::=
                <value expression>
              | <null specification>
              | DEFAULT

         <object column> ::= <column name>

	public static  Date convertDoubleToWindowsTime(double comTime) {
		long result = 0;
		comTime = comTime - 25569D;
		Calendar cal = Calendar.getInstance();
		result = Math.round(86400000L * comTime)
				- cal.get(Calendar.ZONE_OFFSET);
		cal.setTime(new Date(result));
		result -= cal.get(Calendar.DST_OFFSET);

		return cal.getTime();
	}