Adding Identity field dynamically to a sql table

To add an identity field when a table has no identity field use

Select Row_Number() over (order by [any Column name]) as Id,[Col1],col2,..... from [Table Name]