Year: 2005

  • Set sqlcmd initialization file

    By now you probably can tell that I am a big fan of sqlcmd;) Here is one more nugget on sqlcmd that I can throw at you: You can set a variable so that sqlcmd would run a query whenever you launch it from the command line interactively. For example, you can let it run…

  • Customize Oracle sqlplus editor

    In Oracle sqlplus, if you type ed or edit at the command prompt, sqlplus will put the last command into an editor buffer for easy editing. In Windows, the default editor is Notepad. In Unix / Linux, the default editor is usually vi. I have changed the default sqlplus editor on my Windows machine to…

  • sqlcmd presentation at next Chicago Sql Server User Group meeting

    I will do a talk on sqlcmd basics in the next Chicago Sql Server User group meeting. The meeting will be held at Microsoft’s downtown Chicago office on 12/06/2005 from 5:30pm to 8:00pm. More details at here. I will post scripts and slides here when I am done editing. Hope to see you there.

  • Xiamen Pictures

    Xiamen Botanic Garden Originally uploaded by haidong. Last year I went back to my college town, Xiamen, China, for our 10 year graduation reunion. I had my undergraduate education there from 1990 to 1994. Xiamen is absolutely beautiful. I hope you like the pictures. More pictures of Xiamen can be found here.

  • Good Chinese Restaurants in Chicago

    After living in the US for more than 10 years now, I feel that I am also looking forward to Thanksgiving and Christmas holidays. I am not religious, but I like the joyful, harmnious, and just plainly nice spirit these holidays bring. The Chinese equivalent version would be the lunar New Year holiday. On Thanksgiving…