May 2, 2009 at 10:54 pm
I am returning a money datatype for sql to a .net app.
When I retrieve the value from the output parameter the decimal places are not available.
What am I missing here?
-----------------------------
--SQL 08
@ExtendedCost MONEY OUTPUT
as
set nocount on
SELECT @ExtendedCost = SUM(TotalCost) from utbCart
where utbCart.CartID = @CartID
OR utbCart.ShopperID = @ShopperID
and utbCart.UnitCost IS NOT NULL
--.Net
Dam again!
May 3, 2009 at 4:39 am
Hello,
Unfortunately I can’t see the .Net code. The SQL looks Okay though.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
May 3, 2009 at 9:52 am
John Marsh (5/3/2009)
Hello,Unfortunately I can’t see the .Net code. The SQL looks Okay though.
Regards,
John Marsh
Dam again!
May 5, 2009 at 4:07 am
Hi, here you have a documentation of conversion:
http://technet.microsoft.com/en-us/library/ms191530.aspx
and
http://www.tek-tips.com/faqs.cfm?fid=6157
By other way, may be a problem with the point/comma notation
November 5, 2012 at 11:24 pm
More detail you can read tutorial on dapfor. com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply