|
|
|
SSC Rookie
 
Group: General Forum Members
Last Login: 2 days ago @ 10:51 PM
Points: 38,
Visits: 137
|
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Friday, November 20, 2009 7:43 AM
Points: 1,
Visits: 7
|
|
Just a note, you can change the element names if necessary for obfuscation with aliases as well, for example:
SELECT TOP 0 [ID] = MemberAddrID
, [Address1] = Addr1
, [Address2] = Addr2
, [Address3] = Addr3
, [City]
, [State] = ST
, [Zipcode] = Zipcode
FROM dbo.MBR_ADDR AS [MEMBER_ADDRESS]
FOR XML AUTO, XMLSCHEMA;
You're not locked into just following table's structure, you can do this on views as well, nice to see this article since its something that a lot of people don't know about or don't think regularly about.
|
|
|
|
