Invoke-sqlcmd doesn't return data in rows

Question

The Invoke-Sqlcmd doesn't return data in rows, it lists each item separately

This is the code that I'm using:

Invoke-Sqlcmd -ServerInstance "MyServer" -Query "SELECT * FROM [MyDB].[dbo].[MyTable]"

I get something like this:

Key         : 81839
Type        : DELETE
TableName   : InstList
ColumnName  : Key
ID          : 1092110700485
OldValue    : 5216268
NewValue    : 
UpdateDate  : 7/22/2019 12:06:30 PM
UserName    : test
FeatureName : Instruments

Key         : 81840
Type        : DELETE
TableName   : InstList
ColumnName  : Key
ID          : 2101128532011
OldValue    : 5289370
NewValue    : 
UpdateDate  : 7/22/2019 12:06:30 PM
UserName    : test
FeatureName : Instruments

Why does it not come out in rows?

Lukasz Szozda · Accepted Answer · 2019-08-09 20:13:19Z

4

Why does it not come out in rows?

It is only matter or presenting data:

Invoke-Sqlcmd -ServerInstance "MyServer" -Query "SELECT * FROM [MyDB].[dbo].[MyTable]" 
| out-gridview

or:

Invoke-Sqlcmd -ServerInstance "MyServer" -Query "SELECT * FROM [MyDB].[dbo].[MyTable]" 
| Format-Table -AutoSize

edited Aug 9, 2019 at 20:13

answered Aug 9, 2019 at 20:07

Lukasz Szozda

181k26 gold badges278 silver badges326 bronze badges

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

Collectives™ on Stack Overflow

Invoke-sqlcmd doesn't return data in rows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related