Pages

Monday, September 2, 2013

SQL SERVER – Puzzle – Challenge – Error While Converting Money to Decimal | Journey to SQL Authority with Pinal Dave

Earlier I wrote SQL SERVER – Challenge – Puzzle – Usage of FAST Hint and I did receive some good comments. Here is another question to tease your mind. Run following script and you will see that it will thrown an error. DECLARE @mymoney MONEY; SET @mymoney = 12345.67; SELECT CAST(@mymoney AS DECIMAL(5,2)) MoneyInt; GO The… Continue Reading...

Source: SQL SERVER – Puzzle – Challenge – Error While Converting Money to Decimal | Journey to SQL Authority with Pinal Dave