Home Forums SQL Server 2005 Development serial no RE: serial no

  • March 21, 2009 at 3:59 am

    #963948

    SELECT ROW_NUMBER() OVER (ORDER BY CustomerID) AS SerialNo,

    CustomerId,CustomerName FROM dbo.CustMaster