sql server获取表的所有字段

select name+"," from syscolumns where object_name(id)='equipment'
'equipment'为表名.

输出格式改为文本

结果如下：
                                                                                                                                 
---------------------------------------------------------------------------------------------------------------------------------
activestatus,
address,
adviceboard,
aspset_key,
assettag,
attachment,
attachment_des,
attribset,
bovvalue,
businessunit,
city,
comments,
computer_type,
contactequipment,
contractcoverag,
country,
custfield0,
custfield1,
custfield2,
custfield3,
custfield4,
custfield5,
custfield6,
custfield7,
custfield8,
custfield9,
custfieldsavail,
custlabel0,
custlabel1,
custlabel2,
custlabel3,
custlabel4,
custlabel5,
custlabel6,
custlabel7,
custlabel8,
custlabel9,
customerequipment,
customerid,
datecreated,
datemodified,
debtornr,
deliverdate,
deliverynumber,
deliveryposition,
details,
division,
equip_warranty,
ethernet_id,
fsident,
glaccount,
harddisksize,
haswarranty,
history,
hwcontract,
hwcoverage,
installdate,
ipaddress,
IsLock,
linktype,
location,
maintenance_level,
makemodel,
nodename,
notes_key,
ordernumber,
orderposition,
ordertype,
orgequipment,
os_type,
os_version,
perlewbz,
pkey,
port_number,
priority,
prod_warranty,
productequipment,
project_id,
purchasedate,
pwarranty_expires,
ramsize,
sap_info,
satok,
serialnumber,
serregequipment,
servername,
slaavailfactor,
sna_address,
state,
type,
validdate,
vendor,
warranty_expires,
warrantycoverag,
workgroupequipm,
zip,

（所影响的行数为 96 行）

转载于:https://www.cnblogs.com/huang/archive/2006/07/06/444517.html