这里用到了identity关键字:indentity(a,b),a b均为正整数,a表示开始数,b表示步长,indentity(1,1)就代表从1开始,每次增加1
create view view_personas
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
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)