Thanks [email protected] Doe if you have a performance question ask a new question and supply details of the table sizes, structures, indexes and execution plans.I don't understand what you are asking in point 2 please edit your question and supply example table structures that demonstrate the issue you are asking [email protected] Doe: If you mean by column you mean a column value (in other words, a matching row) – when there is no matching row, no error is raised.Specifies the temporary named result set or view, also known as common table expression (CTE), defined within the scope of the UPDATE statement.The CTE result set is derived from a simple query and is referenced by UPDATE statement.Common table expressions can also be used with the SELECT, INSERT, DELETE, and CREATE VIEW statements.For more information, see WITH common_table_expression (Transact-SQL). For information about table hints, see Table Hints (Transact-SQL).The SQL Server (Transact-SQL) UPDATE statement is used to update existing records in a table in a SQL Server database.There are 3 syntaxes for the UPDATE statement depending on whether you are performing a traditional update or updating one table with data from another table.
As you can see that using JOIN clause in UPDATE statement it makes it very easy to update data in one table from another table. Col2 AS _Col2 FROM T1 JOIN T2 ON T1= T2/*Where clause added to exclude rows that are the same in both tables Handles NULL values correctly*/ WHERE EXISTS(SELECT T1. TOP ( ) Specifies one or more table hints that are allowed for a target table. @ When referencing the Unicode character data types nchar, nvarchar, and ntext, 'expression' should be prefixed with the capital letter ' N'.If ' N' is not specified, SQL Server converts the string to the code page that corresponds to the default collation of the database or column.So I need to update the table in the new DB from the table in the old DB which has around 1000 rows.In other words, I need to update the Unfortunately, your question is not clear.