What is the ans for the below query I gave d and like 2but i

Hi frnds What is the ans for the below query I gave d and like 2but it's a wrong. which will be the output of the following code segment? Declare @my_name char(10) = 546875.5 Set @my_name = @my_name +'100' Select @my_name 1. 546875.5100 2. 546975.5 3. 546875.5 4. Conversation failed 5. None of the given output

Hi,

Declare @my_name char(10) = 546875.5
Set @my_name = @my_name +'100'
Select @my_name

Output of above query is 546875.5

And not 546875.5100 and not 546975.5

Clarification -

Though it seems appending or concatenating to exisitng value in ideal scenario "546875.5100" is answer, but SQL server works differently.

If we decalre variable as varchar will get expected or ideal result.

Declare @my_name varchar(10) = 546875.5
Set @my_name = @my_name +'100'
Select @my_name

Output 546875.510 considering sized of 10.

Why so?

Becasue of SQL data types. Char and Varchar.

Char means fixed lenght data and VARCHAR means variable.

So when

Declare @my_name char(10) = 546875.5

Even actual data is of lenght 8, remaining size of type is right padded with spaces.

so here all 10 characters are occupied.

Hence the append/concatination does not work.

Use print and datalength function on char variable to verify this.

See selected are with spaces.

Thanks,

Tushar

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tushar Dikshit9y ago
Accepted answer
Hi,
Declare @my_name char(10) = 546875.5
Set @my_name = @my_name +'100'
Select @my_name
Output of above query is 546875.5
And not 546875.5100 and not 546975.5
Clarification -
Though it seems appending or concatenating to exisitng value in ideal scenario "546875.5100" is answer, but SQL server works differently.

If we decalre variable as varchar will get expected or ideal result.
Declare @my_name varchar(10) = 546875.5
Set @my_name = @my_name +'100'
Select @my_name
Output 546875.510 considering sized of 10.

Why so?
Becasue of SQL data types. Char and Varchar.
Char means fixed lenght data and VARCHAR means variable.

So when
Declare @my_name char(10) = 546875.5

Even actual data is of lenght 8, remaining size of type is right padded with spaces.
so here all 10 characters are occupied.
Hence the append/concatination does not work.

Use print and datalength function on char variable to verify this.

See selected are with spaces.

Thanks,
Tushar
0
Anjali Khan9y ago
Hi zukar n Tushar Thanks for the update.
0
Zakir Ahamed9y ago
Declare @my_name char(10) = 546875.5 Set @my_name = @my_name +'100' Select @my_name

if u execute this Query You get 546875.5 as a answer
0