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
All Tags
»
UPDATE
(RSS)
Browse Blog Posts by Tags
Showing related tags and posts for the
Blogs
application. See
all tags in the site
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 column with a value from another record. Enjoy!
Posted to
General Programming
by
Gal Ratner
on 21 Aug 2009
Filed under:
Filed under:
SQL
,
FROM
,
UPDATE
Page 1 of 1 (1 items)