Update SQL database rows with a dictionary [Answered]

I have the following SQL server table:

id | name | url
--------------
1  | John |
2  | Jane |
3  | Jack |
4  | Jill |

id | name | url
--------------
1  | John |
2  | Jane |
3  | Jack |
4  | Jill |

Where the URL column is empty for all rows.
I have an excel sheet with an id and a url:

1   http://www.google.com
2   http://www.yahoo.com
3   http://www.bing.com

1   http://www.google.com
2   http://www.yahoo.com
3   http://www.bing.com

How can I create an UPDATE / MERGE statement where it will put all the correct URLs in my table?
I know you can do an INSERT like

INSERT INTO Users
    (Id, Url)
VALUES
    (1, 'http://www.google.com'),
    (2, 'http://www.yahoo.com'),
    (3, 'http://www.bing.com')

INSERT INTO Users
    (Id, Url)
VALUES
    (1, 'http://www.google.com'),
    (2, 'http://www.yahoo.com'),
    (3, 'http://www.bing.com')

But I can't find whether you can do this with an UPDATE statement.
You can do

UPDATE Users
SET Url = (
    SELECT Url
    FROM ???
    WHERE Id = Users.Id
)

UPDATE Users
SET Url = (
    SELECT Url
    FROM ???
    WHERE Id = Users.Id
)

But how do I get my data in that query?

C#•4y ago•

9 replies

I have the following SQL server table:

id | name | url
--------------
1  | John |
2  | Jane |
3  | Jack |
4  | Jill |

id | name | url
--------------
1  | John |
2  | Jane |
3  | Jack |
4  | Jill |

Where the URL column is empty for all rows.
I have an excel sheet with an id and a url:

1   http://www.google.com
2   http://www.yahoo.com
3   http://www.bing.com

1   http://www.google.com
2   http://www.yahoo.com
3   http://www.bing.com

How can I create an UPDATE / MERGE statement where it will put all the correct URLs in my table?
I know you can do an INSERT like

INSERT INTO Users
    (Id, Url)
VALUES
    (1, 'http://www.google.com'),
    (2, 'http://www.yahoo.com'),
    (3, 'http://www.bing.com')

INSERT INTO Users
    (Id, Url)
VALUES
    (1, 'http://www.google.com'),
    (2, 'http://www.yahoo.com'),
    (3, 'http://www.bing.com')

But I can't find whether you can do this with an UPDATE statement.
You can do

UPDATE Users
SET Url = (
    SELECT Url
    FROM ???
    WHERE Id = Users.Id
)

UPDATE Users
SET Url = (
    SELECT Url
    FROM ???
    WHERE Id = Users.Id
)

But how do I get my data in that query?