create view v_test 
as

select row_number() over (order by getdate()) as ID,*
from sys.tables

------解决方案--------------------

SQL code
create view vv
as
select row_number() over(order by 列) ,* from 
 a ,b........
where.......