SQL2005提供了新函数：ROW_NUMBER（）
以下为示例：
select ROW_NUMBER() OVER(ORDERBY sAMAccountName DESC) as emp_no,
''as card_no,sAMAccountName as ename,sn+givenname as cname,
''as Gender,''as departmentname,''as job_Rank,telephoneNumber as ext,
Mail as email,''as dlidl,''as enter_date,''as birth_date,'1'as workstate,'DTS'as domain
from\[eipdb\].webeip.dbo.ldap_account
wherereplace(sAMAccountName,'','') notin
(selectdistinctreplace(ename,'','') from empBaseInfo)
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。