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

Question

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

Tushar Dikshit · 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  5 46875.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

Anjali Khan · Answer

Hi zukar n Tushar Thanks for the update.

Zakir Ahamed · Answer

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