Introduction to SQLCMD

  • Comments posted to this topic are about the content posted at

  • I liked the article pace, some of us never got the command line experience...

    Keep them coming!

  • Alex,

    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 Ameena for your kind words. I am glad you liked the material 🙂

    Yes, I will try to present more at our user group meetings, if possible.

    Haidong "Alex" Ji

  • 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 = "" and open the previous editor. Any clue.  Thanks again.

  • I liked the articale very much. However, ed through command line does nothing. I changed SQLCMDEDITOR to "notepad.exe" it didn't work as well. Any clue. Thanks.


  • 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.

    Regards, Vincent

  • 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.

    Thanks again,


  • thank you! a great article!

    is there a forum for sqlcmd issues?

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply