Gal Ratner
Gal Ratner is a Techie who lives and works in Los Angeles.
Sign in
|
Join
|
Help
Home
Blogs
Media
Forums
Schedule
Consulting Services
Store
General Programming
»
All Tags
»
UPDATE
(
RSS
)
Browse by Tags
General Programming
Home
Syndication
RSS for Posts
Atom
Email Notifications
Go
Recent Posts
Update a record in a SQL Server table from another record in the same table
Tags
Bing API
Bulk Image Resizer
Data Warehousing
Dolphin
Enterprise Development
FROM
Javascript
Madison
Mobile
MySql
netsh
Parallel Computing
pstools
Shopping Cart .NET
Software Architecture
software life cycle
SQL
SQL Server 2008
UPDATE
View more
Archives
August 2011 (1)
August 2010 (1)
June 2010 (3)
May 2010 (1)
March 2010 (1)
January 2010 (1)
October 2009 (2)
September 2009 (1)
August 2009 (1)
July 2009 (1)
April 2009 (1)
FROM
SQL
Update a record in a SQL Server table from another record in the same table
In SQL Server you can update record fields with the values from another record using the following TSQL: UPDATE t1 SET t1.MyColumn = t2.MyColumn FROM MyTable AS t1, MyTable AS t2 WHERE t1.ID = @ID1 AND t2.IP = @ID2 This will update your table’s...
Published
22 Aug 2009 4:15 AM
by
Gal Ratner
Filed under:
SQL
,
FROM
,
UPDATE