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
注意，前面还有一点。
