开发者

Opening SQL command from SQL Server 2008?

开发者 https://www.devze.com 2022-12-21 16:35 出处:网络
I cannot find where th开发者_Python百科e sqlcmd is? i just want the prompt. please help!From http://msdn.microsoft.com/en-us/library/ms166559.aspx

I cannot find where th开发者_Python百科e sqlcmd is? i just want the prompt. please help!


From http://msdn.microsoft.com/en-us/library/ms166559.aspx

To start the sqlcmd utility and connect to a default instance of SQL Server On the Start menu click Run. In the Open box type cmd, and then click OK to open a Command Prompt window.

At the command prompt, type sqlcmd.

Press ENTER.

You now have a trusted connection to the default instance of SQL Server that is running on your computer.

1> is the sqlcmd prompt that specifies the line number. Each time you press ENTER, the number increases by one.

To end the sqlcmd session, type EXIT at the sqlcmd prompt.

To start the sqlcmd utility and connect to a named instance of SQL Server Open a Command Prompt window, and type sqlcmd -S myServer\instanceName. Replace myServer\instanceName with the name of the computer and the instance of SQL Server that you want to connect to.

Press ENTER.

The sqlcmd prompt (1>) indicates that you are connected to the specified instance of SQL Server.

Note:
Entered Transact-SQL statements are stored in a buffer. They are executed as a batch when the GO

EDIT: Here's another page that helps with sqlcmd.exe

SQL Server: A crash course in using SqlCmd to manage SQL Server Express

0

精彩评论

暂无评论...
验证码 换一张
取 消