Multiple choice technology web technology

select str('123.45',8,4)

  1. 123.4500

  2. 123.0000

  3. 1234.000

  4. 1234.500
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The STR function in SQL Server converts a numeric value to a string with specified formatting. STR(number, length, decimal_places) converts 123.45 to a string representation with total length 8 and 4 decimal places, resulting in '123.4500'. Option B incorrectly shows the value as 123.0000. Option C and D show incorrect number formatting and decimal placement.

Keep practicing — related questions