how to set two variables for the same column?

Question

suppose i have the following statement

Invoke-Sqlcmd -Query "UPDATE [$Table]
SET [size] = '$newSize.Size $newSize.Unit'
WHERE [cname] = '$cube'" -ConnectionString $CS

this doesnt work and throws the following error:

Invoke-Sqlcmd : String or binary data would be truncated. The statement has been terminated.

in the table, i see this in the field:

@{Size=919.8; Unit=MB}.Size

this is because im setting two variables in one statement, but what is the proper syntax for that?

i am trying to store the following value: 919.8 MB

i tried this: '$estimatedSize.Size','$estimatedSize.Unit'

but it doesnt work either

score 0 · Accepted Answer · edited Aug 17 '19 at 05:26

0

This is the right syntax:

SET [size] = '$($newSize.Size) $($newSize.Unit)'

edited Aug 17 '19 at 05:26

Andronicus

answered Aug 17 '19 at 01:04

Cataster

1 Answers1