DECLARE @n CHAR(100),@fields VARCHAR(1024)
SET @n='MyTABLE' --设置为你的表名
SET @fields=''
SELECT @fields=@fields + ',' + name FROM
(
SELECT TOP 3 sc.name FROM
sysobjects sb
INNER JOIN
syscolumns sc
ON sc.id=sb.id
WHERE sb.xtype='u' AND sb.name=@n
ORDER BY sc.colorder
) base