what is o/p following SQL query?

Question

DECLARE @TestDecimal DECIMAL(8 2) SET @TestDecimal = 275953.00 SELECT CONVERT( DECIMAL @TestDecimal * 0.40 )  CONVERT( DECIMAL @TestDecimal ) * 0.40 1) 110381 110381 2) 110381 110381.20 3) 110381.20 110381 4) 110381.20 110381.20

Lalit M · Answer

2) 110381 110381.20 Because when precision is not specified with the decimal type TSQL will use whatever precision would use the minimum space to store with the number it is converting to. This is why it is important to specify precision when using the CONVERT function.

Nilanka Dharmadasa · Answer

I'm requesting the administrators of this forum to check this question and the accounts of these users properly before deciding to give points to the accepted answer of this question.

Nilanka Dharmadasa · Answer

2) 110381 110381.20