August 9, 2021 at 11:00 pm
DECLARE @test VARCHARSET @test = '[Copy]-'Select @test + 'SomeName'
I want ...
But I get
Please remind me, I have tried / and \ with no luck
August 9, 2021 at 11:07 pm
DECLARE @test-2 VARCHAR(8) '**** Change ****
August 11, 2021 at 5:28 pm
Correct, if the length is not explicitly declared, a VARCHAR type variable is defined as being one byte long. 🙂
varchar [ ( n | max ) ] Variable-size string data.
When n isn't specified in a data definition or variable declaration statement, the default length is 1. If n isn't specified when using the CAST and CONVERT functions, the default length is 30.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply