• Elliott Whitlow (6/19/2013)


    The command SQLCMD is a command line interface to SQL, you type in SQL commands and type GO and it does them. It also allows you to execute a set of commands in a file from the command line. There is not much of an interface and no GUI.

    The management studio provides a nice GUI to work with to do many management tasks, most of which could be accomplished using the SQLCMD command.

    The SQLCMD mode of management studio allows for some conditional logic and string replacement. I don't use it often.

    Without getting too deep there you are..

    CEWII

    thanks for such quick reply.

    but still the same question is there anything that SQLCMD does and SSMS doesn't.