You can cast the float as a different datatype, for example, decimal
select id as Id, name as Name, Cast(Area As decimal(8,2)) As Area from myTable as MyTable where id = 5 for xml auto, Root('DocumentElement'), elements
No comments:
Post a Comment