Development Is Nothing
Saturday, December 18, 2010
SQL Update Multiple Columns
Below Sql use to update multiple column for a table in 1 shot
*****************
UPDATE
Table1
SET (
Col1
,
Col2
,
Col3
,
Col4
) =
(SELECT
Col1a
,
Col2a
,
Col3a
,
Col4a
FROM
Table2
WHERE
Col5a
=
Table1
.
Col5
)
WHERE
Col5
IN (SELECT
Col5a
FROM
Table2
)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment