#数据库配置
$Database = '数据库名称'
#数据库实例名
$Server = '"localhost\SQL2008"'
#用户名
$UserName = 'sa'
#密码
$Password = '数据库密码'
#连接数据库
$SqlConn = New-Object System.Data.SqlClient.SqlConnection
$SqlConn.ConnectionString = "Data Source=$Server;Initial Catalog=$Database;user id=$UserName;pwd=$Password"
#打开数据库连接
$SqlConn.open()
#执行语句方法一
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.connection = $SqlConn
$SqlCmd.commandtext = "update tn_ab_item set CN_C_IN_STOCK='S' WHERE CN_S_ITEM_NAME= '1233' "
$SqlCmd.executenonquery()
$SqlConn.close()