i have a code that query a mssql db as follows :
$query = "SELECT email From Person Where EmployeeID='ESC" + $person.Split(';') +"'"
$command = $connection.CreateCommand()
$command.CommandText = $query
$result = $command.ExecuteReader()
how to recover the email value ??? how should i use $command in order to have one value not a table ?
thank you in advance.