I liked the article pace, some of us never got the command line experience...Keep them coming!
Your presentation today at SSWUG on SQLCMD was very interesting and informative. Now this article of yours makes sense to me. I am basically a GUI person, but I can see the power of command line. I hope to read more of your articles at SQLServerCentral and your presentation at SSWUG meetings.
Thanks for the article! I'm with others here in that it was nice to see something about the command line tools. The article was well written and made me feel quickly at ease with SQLCMD.
Very helpful. Thanks. I try to change default editor and it won't take. It's still SQLCMDEDITOR = "edit.com" and open the previous editor. Any clue. Thanks again.
Thank you for posting this article, Haidong Ji. The "ed" thing is also there in Oracle sqlplus.
Boris. I typed exactly as Haidong suggested and it worked: set sqlcmdeditor = notepad (with set, without the .exe). After I entered sqlcmd, I typed a select statement then I typed ed and notepad popped up. I saved and exit and the statements I typed in notepad are displayed on sqlcmd. It is really handy.
Thank you Vincent. I typed ed right after I entered sqlcmd, and got nothing. Now if I type any statement and then type ed notepad popped up with statement.