Create Temp Table With Identity in SQLVenkat10yPublished Jul 19, 2016, 11:25 AMUpdated Jul 21, 2016, 1:41 AM928CodeCreate temp table with identity in SQL.Some time we need to create temp table with identity in SQL.Below Tip will help tp resolve our issue. SELECT SequentialRowNumber = identity(INT,1,1),ROW_NUMBER() OVER (ORDER BY CustID) AS Row,* into mytit1 from #customers