Use IDENTITY(INT,1,1).

How ever this statement will work only for SELECT INTO type of queries. You may need to change your code a little bit to take care of it.

For eg  SELECT...