SQLServerCentral / Discuss Content Posted by Haidong Ji / Article Discussions / Article Discussions by Author / Introduction to SQLCMD / Latest Posts

RE: Introduction to SQLCMD

ShellyP — Wed, 30 Jan 2008 09:02:46 GMT

thank you! a great article! is there a forum for sqlcmd issues?

RE: Introduction to SQLCMD

bshimonov — Thu, 25 Jan 2007 09:56:00 GMT

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,

RE: Introduction to SQLCMD

VincentRainardi — Wed, 24 Jan 2007 15:59:00 GMT

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

RE: Introduction to SQLCMD

bshimonov — Fri, 12 Jan 2007 12:08:00 GMT

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.

RE: Introduction to SQLCMD

Min Yue — Thu, 11 Jan 2007 07:36:00 GMT

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.

RE: Introduction to SQLCMD

RhondaVeit — Thu, 11 Jan 2007 05:38:00 GMT

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.

Thanks!Rhonda

RE: Introduction to SQLCMD

Haidong Ji — Sat, 14 Jan 2006 07:37:00 GMT

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" Jihttp://www.HaidongJi.com

RE: Introduction to SQLCMD

Ameena Lalani — Thu, 12 Jan 2006 22:00:00 GMT

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.

Regards,

Ameena

RE: Introduction to SQLCMD

Augustin Carnu — Wed, 11 Jan 2006 10:26:00 GMT

I liked the article pace, some of us never got the command line experience...Keep them coming!

Introduction to SQLCMD

Haidong Ji — Mon, 02 Jan 2006 12:44:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/hji/introductiontosqlcmd.asp