PowerShell笔记（三）：调用MS SQL数据库

试了一把PowerShell访问数据库，跟用C#写几乎没任何区别~

为了简单起见，代码有点丑，不用太深究

$ConnString = "server=_SERVER_;database=_DATABASE_;user id=_UID_;password=_PWD_";
$db = New-Object System.Data.SqlClient.SqlConnection($ConnString);

$db.Open();

 

$Sql = "select top 10 * from sys.objects where type='U' order by [Name]";
$cmd = New-Object System.Data.SqlClient.SqlCommand($Sql,$db);

 

$r = $cmd.ExecuteReader();

$a = "","";

 

while ($r.Read())
{
 $a = $a + $r["Name"].ToString();
}

 

$r.Close();
$cmd.Dispose();
$db.Close();
$db.Dispose();

 

 

echo $a