select id=row_number() over(order by getdate()),* from 视图

产生唯一值很简单 

select newid() as 列名,* from 表 

--创建视图 
create view view_name
as
--
 select * from tb_test
--
go