DaniWeb Forum Index
>
Search Forums
Search Results
•
•
•
•
Showing results 1 to 1 of 1
Search took
0.01
seconds.
Search:
Posts Made By:
rchokler
Save these search results for 24 hours
Forum:
MS SQL
May 13th, 2007
Replies:
1
update two rows in one query
Views:
5,606
Posted By
rchokler
update two rows in one query
UPDATE table1
SET ID,[DESC] =
( SELECT ID,[DESC]
FROM tmptable
WHERE tmptable.ID_SUN = table1.ID_SUN)
WHERE EXISTS
( SELECT ID,[DESC]
FROM tmptable
WHERE tmptable.ID_SUN = [Table1].ID_SUN)...
Showing results 1 to 1 of 1
Latest Posts
Today's Posts
All Forums
Unanswered Threads
All Forums
Related Forum Features
DaniWeb News Stories
DaniWeb Code Snippets
DaniWeb Tutorials
DaniWeb Product Reviews
DaniWeb White Papers
Forum Search
About Us
|
Contact Us
|
Advertise
|
DaniWeb
|
Acceptable Use Policy
|
©2003 - 2010 DaniWeb® LLC