sqlserver数据库新创建视图，增加一列自增id ，列名就为ID，小生语句在补充，求正确sql语句，谢谢

Question

create view view_person
as
select
a.strName as strName,
convert(nvarchar(20),CardID) as nLOCardNo
from view_one as a inner join (select distinct CardID,EmpSysID from MJ_MjData)
as b on a.EmpSysID=b.EmpSysID

Answer 1

create view view_person
as
select ROW_NUMBER() over(order By a.strName) as ID,--想按什么排序就order By什么
 a.strName as strName,
convert(nvarchar(20),CardID) as nLOCardNo 
from view_one as a inner join (select distinct CardID,EmpSysID from MJ_MjData) 
as b on a.EmpSysID=b.EmpSysID

本回答被提问者采纳