如何用cmd执行SQL语句

如何用cmd执行SQL语句

osql -S"127.0.0.1" -U"sa" -P"123456" -d"CZBANK"1>select * from dbo.CZBANK2>go

使用PowerShell吧

C:\Documents and Settings\Administrator>osql help
用法: osql [-U login id] [-P password]
[-S server] [-H hostname] [-E trusted connection]
[-d use database name] [-l login timeout] [-t query timeout]
[-h headers] [-s colseparator] [-w columnwidth]
[-a packetsize] [-e echo input] [-I Enable Quoted Identifiers]
[-L list servers] [-c cmdend] [-D ODBC DSN name]
[-q "cmdline query"] [-Q "cmdline query" and exit]
[-n remove numbering] [-m errorlevel]
[-r msgs to stderr] [-V severitylevel]
[-i inputfile] [-o outputfile]
[-p print statistics] [-b On error batch abort]
[-X[1] disable commands [and exit with warning]]
[-O use Old ISQL behavior disables the following]
批处理
控制台宽度自动调整
宽消息
默认错误级别为 — 1 对 1 这是我的CMD打印出来的,装了SQL SERVER 就行了执行语句需要在后面加GO1> select name from sysdatabases
2> go