|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Friday, May 17, 2013 11:29 AM
Points: 60,
Visits: 303
|
|
|
|
|
|
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.
|
|
|
|