The Ji Village News

Author: Haidong Ji

  • Company Christmas parties

    Companies in the US usually hold Christmas parties in December. I don’t know about other western countries, but I wouldn’t be surprised if they have similar customs. Normally, one should dress formally in these parties. For man, that means suit, tie, dress shoes, and such. I didn’t know that when I started working in the…

  • Essential Software for Windows Machine

    Update 20100915: added WinSplit Update 20090830: took out anti-virus software. I now run Windows without it. Also, added CDBurnerXP. This entry was originally posted on November 22, 2005. I made some modifications to it. Right now I am giving Google Reader a try. Therefore FeedDemon is not part of my essentials anymore. I recently rebuilt…

  • Discarded newsletter piece

    Imagine you have a time machine at hand. Rewind back a few years, or decades, depending on where you are in your life, to the point when you were fresh out of university, got your first job, and ready to change the world. You were full of enthusiasm and ideas. You were still in touch…

  • Executing sql scripts using command line tools

    SQL Server 2005 has a command line tool named sqlcmd. MySQL has a command line tool named mysql. Oracle has a command line tool called sqlplus. They can all be used for interactive query processing and batch scripts processing. They do similar things, albeit in different ways. They are functionally equivalent. For SQL Server 2005,…

  • desc is sp_columns in Sql Server

    In Oracle and MySql, to get the column name and data type of a table, you can use: desc MyTable or describe MyTable The equivalent of desc in Sql Server is sp_columns. Therefore, run the command below will get similar results: sp_columns MyTable