SQL SERVER – How to create an IDENTITY/Auto Increment column in a SELECT into table statement

Most of the SQL Developers, Programmers know how to create an IDENTITY column in SQL Server and also what is its purpose and why is it used? But here I am going to explain how to create an IDENTITY column in Select statement.

Note: we can use this Query only in select statement where we are creating a table in a select statement.