<div>
Thanks for pointing to use Executereader. Somehow, I am getting issues with this. I used a different approach to get the work done. Thanks.
</div>


Thanks for pointing to use Executereader. Somehow, I am getting issues with this. I used a different approach to get the work done. Thanks.

<div>
<div class="content wysiwyg-content">
This URL stackoverflow.com/question<wbr />s/1758779/<wbr />retrieving<wbr />-data-usin<wbr />g-select-s<wbr />ql-stateme<wbr />nt-in-powe<wbr />rshell helped in retrieving data from SQL query into a variable.<br />
I would like to enhance this to retrieve multiple values.<br />
<br />
$SqlCmd.CommandText = &quot;select column1,column2 from table1&quot;<br />
$column1 = $SqlCmd.ExecuteScalar()<br />
<br />
How can I assign column2 value into a variable. <br />
<br />
Thanks<br />
Sharath
</div>
</div>


This URL stackoverflow.com/questions/1758779/retrieving-data-using-select-sql-statement-in-powershell helped in retrieving data from SQL query into a variable.
I would like to enhance this to retrieve multiple values.

$SqlCmd.CommandText = "select column1,column2 from table1"
$column1 = $SqlCmd.ExecuteScalar()

How can I assign column2 value into a variable. 

Thanks
Sharath

Retrieving data using select SQL statement in Powershell

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.