_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
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 企.
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-05-03 23:00:17Anonymous