DECLARE @counter int SET @counter = (SELECT MAX(av0_numerator)+1 FROM sl.dbo.av0_style) UPDATE sl.dbo.av0_style SET @counter = av0_numerator = @counter + 1 WHERE av0_numerator= 0

https://haacked.com/archive/2004/02/28/sql-auto-increment.aspx/

the next following number: DECLARE @counter int SET @counter = (SELECT MAX(av0_numerator) FROM sl.dbo.av0_style) UPDATE sl.dbo.av0_style SET @counter = av0_numerator = @counter + 1 WHERE av0_numerator= 0 10.10.19 check later if there are no duplicated: SELECT b.av0_style ,b.av0_numerator ,COUNT(*) AS dupes FROM [SL].dbo.av0_style AS b GROUP BY b.av0_style,b.av0_numerator HAVING (COUNT(*) > 1) 10.10.19

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024