廣告：

sqlcmd -E

附加數(shù)據(jù)庫

osql -E -Q "sp_attach_db @dbname = N'drdata', @filename1 = N'D:\WD-Acquire\db\db_wdfpd\DrData200.mdf', @filename2 = N'D:\WD-Acquire\db\db_wdfpd\DrData_log200.ldf'"

osql -S servername -U username -P password -Q "sp_attach_single_file_db @dbname = N'MyDatabase', @physname = N'D:\Data\MyDatabase.mdf'"

顯示數(shù)據(jù)庫：

osql -S <服務(wù)器名> -E -Q "SELECT name FROM master..sysdatabases WHERE name NOT IN ('master', 'model', 'msdb', 'tempdb')"

osql -S <服務(wù)器名> -U <用戶名> -P <密碼> -Q "SELECT name FROM master..sysdatabases WHERE name NOT IN ('master', 'model', 'msdb', 'tempdb')"

廣告：