Identfying SQL Server NULL in Powershell

Question

Below is code snippet from Powershell

$query =  "select MAX(convert(varchar(10),server_time,102))from status_history where status not like ('ERROR FETCHING%')" 
$servers = Invoke-Sqlcmd2 -query $query -ServerInstance "100.81.60.2" -Database "temp" -Username "temp" -password "temp"

I need to check in Powershell if the sql query contained in $query returns NULL. I tried using

if($servers.Column1 -eq NULL)

but it doesnt seem to work.

try using if($servers.Column1 -eq $null) or just omit it: if ($servers.Column1) — Martin Brandl
– Martin Brandl, Commented Mar 29, 2016 at 13:20
Using if ($servers.Column1) is not a good idea in this context, because values like 0 or "" (empty string) also evaluate to $false. I'd try [DBNull]::Value.Equals(). — Ansgar Wiechers
– Ansgar Wiechers, Commented Mar 29, 2016 at 13:27

Ansgar Wiechers · Accepted Answer · 2016-03-29 14:22:37Z

2

Compare the result to [DBNull]::Value:

if ([DBNull]::Value.Equals($server.Column1)) {
  ...
}

If $server.Column1 contains more than one value you may need to check each value individually.

answered Mar 29, 2016 at 14:22

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Identfying SQL Server NULL in Powershell

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related