Unanswered: Store 'money' in SQL Server 2K with Updategrams
Iīm trying to store a xml updategram into my SQLServer 2k database. Everything works fine until I try to store a value into a field of Money type. I get the message that I should use the CONVERT function to change the type from nvarchar(in the xml updategram) to money (the db field).
How do I do this??
When I fetch from the database with FOR XML the conversion goes by itself...