using …

Pure C#

Archive for the ‘Update with Join’ Category

SQL Server / T-SQL Tutorial

Posted by esersahin on 20/03/2009


http://www.java2s.com/Tutorial/SQLServer/CatalogSQLServer.htm

Posted in Cast, Common Table Expressions, Cross-Tabs, CTE, Functions, Instead Of, Pivot Tables, Raiserror, ROW_NUMBER, SQL, Sql Server, Sql Server Error, Sql Server Join, SQLCLR, Stored Procedure, Transact-SQL, Trigger, UNION, UNION ALL, Update with Join | Leave a Comment »

SQL Server Update with a join

Posted by esersahin on 17/03/2009


http://www.ruslansivak.com/index.cfm/2007/1/11/SQL-Server-Update-with-a-join

Have you ever needed to update one table based on the contents of another table? The way to do it is with aliases.

update t1 set t1.field=replace(t1.field, t2.field1, t2.field2) from table1 t1 inner join table2 t2 on t1.primaryKey=t2.foreignkey

Posted in Update with Join | Leave a Comment »

A CROSS JOIN clause is automatically inserted into an UPDATE statement that uses an INNER JOIN clause when you execute the statement in the SQL pane of SQL Server Management Studio

Posted by esersahin on 17/03/2009


http://support.microsoft.com/kb/953119

Posted in Update, Update with Join | Leave a Comment »