Excel读入Matlab函数(Excel read in a Matlab function)

 看一下sp_msforeachtable的参数。 其中一个是@replacechar，默认情况下是一个问号（即？）。 随意传递另一个同样不太可能出现在查询中的字符（可能是^）。 
 
 当然，如果我没有提到这取决于你想要做什么（我会争辩说你试图在所有桌子上做的任何东西都是这样做的话），我会失职，这样更容易在powershell中读取（和写入）解决方案： 
 
import-module sqlps -disablenamechecking;
$s = new-object microsoft.sqlserver.management.smo.server '.';
foreach ($db in $s.databases) {
   foreach ($table in $db.Tables) {
      $table | select parent, name; --merely list the table and database
   }
}

Take a look at the parameters for sp_msforeachtable. One of them is @replacechar which, by default, is a question mark (i.e. ?). Feel free to pass in another equally unlikely character to occur in a query (maybe a ^).
 
Of course, I'd be remiss if I didn't mention that depending on what you're trying to do (and I would argue that anything that you're trying to do over all tables is doable this way), there are easier to read (and write) solutions in powershell:
 
import-module sqlps -disablenamechecking;
$s = new-object microsoft.sqlserver.management.smo.server '.';
foreach ($db in $s.databases) {
   foreach ($table in $db.Tables) {
      $table | select parent, name; --merely list the table and database
   }
}