sql server 2000µ¼³ö±í½á¹¹

sql server 2000µ¼³ö±í½á¹¹
1.
SELECT   
±íÃû=case when a.colorder=1 then d.name else '' end,   
±í˵Ã÷=case when a.colorder=1 then isnull(f.value,'') else '' end,   
×Ö¶ÎÐòºÅ=a.colorder,   
×Ö¶ÎÃû=a.name,   
±êʶ=case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end,   
Ö÷¼ü=case when exists(SELECT 1 from sysobjects where xtype='PK' and parent_obj=a.id and name in (   
SELECT name from sysindexes WHERE indid in(   
SELECT indid from sysindexkeys WHERE id = a.id AND colid=a.colid   
))) then '√' else '' end,   
ÀàÐÍ=b.name,   
Õ¼ÓÃ×Ö½ÚÊý=a.length,   
³¤¶È=COLUMNPROPERTY(a.id,a.name,'PRECISION'),   
СÊýλÊý=isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0),   
ÔÊÐí¿Õ=case when a.isnullable=1 then '√'else '' end,   
ĬÈÏÖµ=isnull(e.text,''),   
×Ö¶Î˵Ã÷=isnull(g.[value],'')   
into tempdb   
from syscolumns a   
left join systypes b on a.xusertype=b.xusertype   
inner join sysobjects d on a.id=d.id and d.xtype='U' and d.name<>'dtproperties'   
left join syscomments e on a.cdefault=e.id   
left join sysproperties g on a.id=g.id and a.colid=g.smallid   
left join sysproperties f on d.id=f.id and f.smallid=0   
--where d.name='Òª²éѯµÄ±í' --Èç¹ûÖ»²éѯָ¶¨±í,¼ÓÉÏ´ËÌõ¼þ   
order by a.id,a.colorder  
 2.  exec   master..xp_cmdshell   'bcp   "select   *   from   servername.dbo.tempdb"     queryout   "c:\abc.txt"   -t,   -c   -SDD   -Usa   -Pxxx' 
˵Ã÷£º
SQL2000ϵͳ±íµÄÓ¦ÓÃ
--1£º»ñÈ¡µ±Ç°Êý¾Ý¿âÖеÄËùÓÐÓû§±í
select Name from sysobjects where xtype='u' and status>=0
--2£º»ñȡijһ¸ö±íµÄËùÓÐ×Ö¶Î
select