Monday, October 28, 2013

Using For XML Auto ?

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

Tom

No comments:

Post a Comment