_覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁 |
FrontPage › AD螻譟壱
|
|
select replace(substring(DistinguishedName, 1, charindex(',', DistinguishedName)-1), 'CN=', '') 企 , SamAccountName ID , mail , cn , co from OPENROWSET( 'ADsDSOObject' , 'User ID=覃\螻;Password=れ;ADSI Flag=0x11;Page Size=10000' , 'select SamAccountName, DistinguishedName, mail, cn, co from ''LDAP://覃/OU=れ,OU=OU,DC=覃,DC=COM''' ) a where 1=1 and DistinguishedName like '%伎%'
openrowset朱 覃, linked server 誤螻 openquery 企.
鏤
|
覩酔 蠍磯るΜ 蟆 企. 讌 覩酔 螳譟る 讌蠍 螻 . |