ROW_NUMBER() in einem Update Statement //MSSQL

Um In einer Tabelle eine durchnummerirte Spalte einzufügen kann man folgende Anweisung nutzen:

Alter Table [Table1] add ID_ int

WITH TMP1 AS ( SELECT [ID_] ,ROW_NUMBER()over(order by Feld1,Feld2) as Seq FROM Table1 )
UPDATE TMP1 SET [ID_] = Seq

Monday, October 19, 2009 12:11 PM

Your Comments.

# re: ROW_NUMBER() in einem Update Statement //MSSQL

Warum sollte jemand so etwas machen wollen? ;)

Left by Robert Wachtel at 10/19/2009 2:49 PM

# re: ROW_NUMBER() in einem Update Statement //MSSQL

in meinem Fall brauchte ich nach einem Datenimport dieses feld als Primary Key...

Left by Chris Cluss at 10/26/2009 5:19 PM

Your Reply.

Comment Form.

Fields denoted with a "*" are required.

*Your name:

*Subject:

You may also like to leave your email or website.

*Your message:

Please add 5 and 6 and type the answer here:

Enter the code shown above:

nibblers revenge