Conversion of db table into xml

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Conversion of db table into xml

Author

Topic

maifs
Yak Posting Veteran

57 Posts

Posted - 2010-08-09 : 01:12:42

i have a database in SQL 2005.

i need to convert two of them in xml with complete architecture/format and data.

e.g:

Table A

(

ID int pk,

age int ,

name varchar(50),

group varchar(50))

Table B

(

Roll_No int FK(ID,age)

)

etc.

Data:

Select * from A;

ID age name group
1 22 ahmed Pre_medical
2 23 tania Pre_eng
3 25 ahsan A-level

Select * from B;

Roll_No

122
223
325

Sachin.Nand

2937 Posts

Posted - 2010-08-10 : 04:28:15

Can you post some sample o/p of what you need?

Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless.

PBUH

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources