--表結(jié)構(gòu)生成XML文檔

create table ##tb(re varchar(8000))
insert into ##tb 
select '<?xml version=''1.0'' encoding="gb2312"?>
<數(shù)據(jù)庫>'+db_name()

insert into ##tb
select case b.colid when 1 then '<表名>'+a.name else '	' end+'
	<字段 名稱="'+b.name+'"'+case when g.value is null then ''
		else ' 說明="'+cast(g.value as varchar(8000))+'"' end+'/>'
	+case b.colid when (select max(colid) from syscolumns where id=a.id)
		then '
</表名>' else '' end
from sysobjects a 
	join syscolumns b on a.id=b.id
	left join sysproperties g on b.id=g.id and b.colid=g.smallid  
where a.xtype='U'
order by a.name,b.colid

insert into ##tb values('</數(shù)據(jù)庫>')

--生成 c:\a.xml
exec master..xp_cmdshell 'bcp ##tb out c:\a.xml /c'
drop table ##tb