Blog

I’m experiencing weird behaviour using sqlcmd (powershell cmdlet). If I use a select * in the query I get proper result, if I specify a column (n)varchar(max) I get three dots (…) Invoke-Sqlcmd -ServerInstance $ SQLServer -Database $ DBName -Username $ UserDB -Password $ WW -Query “SELECT * FROM [admin].[datafactory_Generated_ET]” Result: TABLE_NAME : datafactory_sourcetables GENERATED_ETRead more