---
title: "Loop vid update Sql2005"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/173161-loop-vid-update-sql2005"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "yoggi"
published: "2008-08-04T19:38:22.000Z"
updated: "2008-08-05T09:51:11.000Z"
replies: 1
views: 363
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/173161-loop-vid-update-sql2005"
---

# Loop vid update Sql2005

## #1 — yoggi, 2008-08-04T19:38Z

Skall köra denna rutin mot en tabell men kan man använda loop vid en update i sql uttrycket istället för köra 100,000 rader hehe.

\<code\>
UPDATE \[CosmosVenture\].\[dbo\].\[CV_Object\]  SET \[CV_Photo\] = 'images/objects/1/main/1.jpg’ WHERE \[AH_ObjectID\] = ‘1'								
UPDATE \[CosmosVenture\].\[dbo\].\[CV_Object\]  SET \[CV_Photo\] = 'images/objects/XXX/main/xxx.jpg’ WHERE \[AH_ObjectID\] = 'xxx'														
UPDATE \[CosmosVenture\].\[dbo\].\[CV_Object\]  SET \[CV_Photo\] = 'images/objects/100000/main/100000.jpg’ WHERE \[AH_ObjectID\] ='‘100000'
\</code\>

Permalänk: https://www.webforum.nu/p/173161

## #2 — LarsG, 2008-08-05T09:51Z

```
declare @item int
declare @name varchar(10)
set @item = 1
while @item <= 100000
begin
      set @name = cast(@item as varchar(10))
      UPDATE [CosmosVenture].[dbo].[CV_Object] 
           SET [CV_Photo] = 'images/objects/' + @name + '/main/' + @name + '.jpg’ 
       WHERE [AH_ObjectID] = @item
      set @item = @item + 1
end
```

Permalänk: https://www.webforum.nu/p/2128799

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/173161-loop-vid-update-sql2005