PowerShell 脚本 参数 运行

PowerShell 脚本 参数 运行
文件命名为：a.psl

 1 param
 2 (
 3 $number
 4 )
 5 $SqlConnection = New-Object System.Data.SqlClient.SqlConnection 
 6 $SqlConnection.ConnectionString = "Server=192.168.0.1;Database=a;user=aaa;pwd=bbb" 
 7 $SqlCmd = New-Object System.Data.SqlClient.SqlCommand 
 8 $SqlCmd.Connection = $SqlConnection 
 9 $SqlCmd.CommandText = "Select * FROM Pay_Detail WHERE (FyNumber = $number)"
10 $SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter 
11 $SqlAdapter.SelectCommand = $SqlCmd 
12 $DataSet = New-Object System.Data.DataSet 
13 $SqlAdapter.Fill($DataSet) 
14 $SqlConnection.Close() 
15 $DataSet.Tables[0]

打开PowerShell 运行：

1 .\a 4217  

注意，前面还有一点。

转载于:https://www.cnblogs.com/xyzabc0004/archive/2012/03/23/2415043.html