2005-03-04 テーブルに列を追加して連番を振るには SQLServer USE Northwind GO SELECT IDENTITY (int, 1000, 1) AS RANK,ProductName INTO #moomoo FROM Products SELECT* FROM #moomoo DROP TABLE #moomoo