Create 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

  

1. SELECT SequentialRowNumber = identity(INT,1,1),ROW_NUMBER()   
2.         OVER (ORDER BY CustID) AS Row,* into mytit1 from #customers