SQL ROW_NUMBER() 临时生成自增序列

如果只是查询时需要生成递增序列：

SELECT 
    ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) + 起始值 - 1 AS RowID,
    -- 其他列
    Column1,
    Column2
FROM YourTable;

示例（从10开始）：

SELECT 
    ROW_NUMBER() OVER (ORDER BY ProductName) + 9 AS ProductNum,
    ProductName,
    Price
FROM Products;