如何从 PowerShell 调用 SQL Server 存储过程? [英] How do I call a SQL Server stored procedure from PowerShell?

问题描述

我有一个很大的 CSV 文件，我想为每一行执行一个存储过程.

I have a large CSV file and I want to execute a stored procedure for each line.

从 PowerShell 执行存储过程的最佳方法是什么?

What is the best way to execute a stored procedure from PowerShell?

推荐答案

此答案来自 http://www.databasejournal.com/features/mssql/article.php/3683181

这个相同的例子可用于任何即席查询.让我们执行如下所示的存储过程sp_helpdb".

This same example can be used for any adhoc queries. Let us execute the stored procedure "sp_helpdb" as shown below.

$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
$SqlConnection.ConnectionString = "Server=HOME\SQLEXPRESS;Database=master;Integrated Security=True"
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.CommandText = "sp_helpdb"
$SqlCmd.Connection = $SqlConnection
$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
$SqlAdapter.SelectCommand = $SqlCmd
$DataSet = New-Object System.Data.DataSet
$SqlAdapter.Fill($DataSet)
$SqlConnection.Close()
$DataSet.Tables[0]

这篇关于如何从 PowerShell 调用 SQL Server 存储过程?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！