|
|
|
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.
|
|
|
|