SQL SERVER – Solution – Puzzle – Challenge – Error While Converting Money to Decimal
- by pinaldave
Earlier I had posted quick puzzle and I had received wonderful response to the same. Today we will go over the solution.
The puzzle was posted here: SQL SERVER – Puzzle – Challenge – Error While Converting Money to Decimal
Run following code in SSMS:
DECLARE @mymoney MONEY;
SET @mymoney = 12345.67;
SELECT CAST(@mymoney AS DECIMAL(5,2)) MoneyInt;…
