PowerShell 5.1 Why same query on different 2016 sp1/sp3 databases return different types

Viewed 66

PowerShell 5.1
SQL Server 2016 SP1 and SP3

If I run an identical select top 1 query between 2 SQL Server 2016 databases (one is on sp3, other is sp1) they return different types, why?

$res = Invoke-Sqlcmd -Query "select top 1 * from customer" -ServerInstance "(localdb)\MSSQLLocalDB" -Database "Database1" -OutputAs DataTables
$res.GetType()
$res

One database returns a DataTable and other returns DataRow

enter image description here

0 Answers
Related