Monthly Archives: November 2006

Active Directory Command Line

Active directory provides command line to manage it. Dsquery is one of the very powerful command.It can finds specific object type in the directory. Dsquery computer: browse computers;Dsquery contact: browse contacts;Dsquery user: browse usersDsquery group: browse groupsDsquery ou: browse orignazition … Continue reading

Posted in Other Programming | Leave a comment


CASE expression is a very useful when we need to branch our output in a query. However, we should always to include a ELSE subcondition in the branch because SQL server assumes that a "ELSE NULL" is included if the … Continue reading

Posted in SQL server | Leave a comment