DECLARE @mynum decimal (18,2)
SET @mynum = 456.25
SELECT FORMAT(@mynum,'000000.0000')
Watch video SQL Queries||How to add leading zeroes before and after decimal in sql? online without registration, duration hours minute second in high quality. This video was added by user LearnSQLtoSSIS 26 March 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 235 once and liked it 4 people.