Gal Ratner is a Techie who lives and works in Los Angeles CA and Austin TX.
Browse Blog Posts by Tags
Showing related tags and posts for the
all tags in the site
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 column with a value from another record. Enjoy!
on 21 Aug 2009
Page 1 of 1 (1 items)