Yasvant M

Yasvant M

  • NA
  • 10
  • 0

what is o/p following SQL query?

Dec 18 2009 1:30 AM
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

Answers (3)