•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 428,578 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,676 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 3139 | Replies: 1
 |
•
•
Join Date: May 2007
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
UPDATE table1
SET ID,[DESC] =
(SELECT ID,[DESC]
FROM tmptable
WHERE tmptable.ID_SUN = table1.ID_SUN)
WHEREEXISTS
( SELECT ID,[DESC]
FROM tmptable
WHERE tmptable.ID_SUN = [Table1].ID_SUN)
I tired this but i coudn't uptade tow columns at once
do i need to seperate them or i have any mistake?
SET ID,[DESC] =
(SELECT ID,[DESC]
FROM tmptable
WHERE tmptable.ID_SUN = table1.ID_SUN)
WHEREEXISTS
( SELECT ID,[DESC]
FROM tmptable
WHERE tmptable.ID_SUN = [Table1].ID_SUN)
I tired this but i coudn't uptade tow columns at once
do i need to seperate them or i have any mistake?
•
•
Join Date: Mar 2007
Posts: 28
Reputation:
Rep Power: 0
Solved Threads: 0
Light Poster
Yes, you need to separate them. The syntax should be more like
It doesn't look like you need a subquery either. A simple join should be sufficient. Something like
UPDATE SomeTable
SET Column1 = SomeValue1,
Column2 = SomeValue2,
Column3 = ....It doesn't look like you need a subquery either. A simple join should be sufficient. Something like
UPDATE t1
SET t1.ID = tmp.ID,
t1.[DESC] = tmp.[DESC]
FROM
tmptable tmp INNER JOIN table1 t1
ON tmp.ID_SUN = t1.ID_SUN |
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- help a newbie? mySQL find & replace (MySQL)
- how to delete duplicate record in a table by using SQL query (MS SQL)
- Double MySQL Query (PHP)
- Using MySQL with PHP - Tutorial by Herong (MySQL)
- updating multiple rows with one form (PHP)
- multiple row update (C#)
- how do i update to Access db? (C#)
- Mysql num rows(): Invalid argument (PHP)
- Querying within the results of a previous query? (MySQL)
- vb6 update record in the database (Visual Basic 4 / 5 / 6)
Other Threads in the MS SQL Forum
- Previous Thread: Query Total Asset
- Next Thread: Checking for banned words
