Question

我写了这份简便的批量文件,但如果我输入包含“-”性质的数据库名称,则失败。难道不确切地说,为什么,但我希望我能这样说?

:: open DB batch file
@echo off
:: starts Sql Server Management Studio Express 2005
:: and opens it to a specific database with query
:: window already open

cls

:SHOWDBNAMES
echo Database names detected on this system:
echo.
"%PROGRAMFILES%Microsoft SQL Server90ToolsBinnOSQL.EXE" -h-1 -S . -E -Q "SELECT CAST(name AS VARCHAR(30)) FROM sysdatabases"

@echo.
set DBNAME=
set /P DBNAME=What database name would you like to open (choose from list)? 

if "%DBNAME%" == "" (
  echo.
  echo I don t recognize your selection. Try again.
  goto SELECTDB
)

:SHOWTABLES
cls
echo.
echo Tables that you can query from %DBNAME% are:
echo.
"%PROGRAMFILES%Microsoft SQL Server90ToolsBinnOSQL.EXE" -h-1 -S . -E -Q "use [%DBNAME%];SELECT CAST(name AS VARCHAR(30)) FROM sys.Tables ORDER BY name"
echo.

:RUNIT
sqlwb.exe -nosplash -S . -E -d %DBNAME%

pause
:EOF

Answer 1

3. 在方括号内附上数据库名称:

http://www.ohchr.org。

下面是工作——你需要以唱名的方式引用数据库名称。注

:SHOWTABLES
cls
echo.
echo Tables that you can query from %DBNAME% are:
echo.
"%PROGRAMFILES%Microsoft SQL Server90ToolsBinnOSQL.EXE" -h-1 -S . -E -Q "SELECT CAST(name AS VARCHAR(30)) FROM [%DBNAME%].sys.Tables ORDER BY name"
echo.

:RUNIT
sqlwb.exe -nosplash -S . -E -d "%DBNAME%"

我要问的是,这一说法是什么? 设在SSMS的试探员免费向你们提供所有这些信息。

另外,你的笔录还考虑到除违约外的服务器机箱——服务器快递被安装为<机关-名称和编号;SQLEXPRESS<>/代码。

Answer 2

为什么不要让你试图强调(_)?

Answer 3

当仪表是数据库名称的第一封信时,它是否在<代码>sqlwb.exe线上失败? 如果是的话,你的问题是,sqlwb正在误用数据库名称作为指挥线选择。应当采取某种方式,使其不这样做;检查手册。

友情链接