select name from syscolumns where id = object_id('table_name') order by colid
select name from syscolumns where id = object_id('table_name') order by colid
create table tb1 ( A varchar(20), B varchar(20), C int )select name from syscolumns where id = object_id('tb1') order by colidname -------------------------------------------------------------------------------------------------------------------------------- A B C(3 行受影响)
select name from syscolumns where id = object_id('table_name') order by colid
A B C ---------- ------------ ----------- (所影响的行数为 0 行)name ----------------------------- ABC(所影响的行数为 1 行)
create table t ( A varchar(10), B dec(10,2), C int) select * from tdeclare @t int declare @str nvarchar(4000) declare @tem nvarchar(255) set @str='' set @tem='' set @t= (select min(colorder) from syscolumns where id = object_id('t')) while @t <=(select max(colorder) from syscolumns where id = object_id('t')) begin select @tem= name from syscolumns where id = object_id('t') and colid=@t set @str=@str+@tem set @t=@t+1end; select @str name drop table t A B C ---------- ------------ ----------- (所影响的行数为 0 行)name ----------------------------- ABC(所影响的行数为 1 行)
(
A varchar(20),
B varchar(20),
C int
)select name from syscolumns where id = object_id('tb1') order by colidname
--------------------------------------------------------------------------------------------------------------------------------
A
B
C(3 行受影响)
where id = object_id('table_name') order by colid
---------- ------------ ----------- (所影响的行数为 0 行)name
-----------------------------
ABC(所影响的行数为 1 行)
( A varchar(10),
B dec(10,2),
C int)
select * from tdeclare @t int
declare @str nvarchar(4000)
declare @tem nvarchar(255)
set @str=''
set @tem=''
set @t= (select min(colorder) from syscolumns where id = object_id('t'))
while @t <=(select max(colorder) from syscolumns where id = object_id('t'))
begin
select @tem= name from syscolumns where id = object_id('t') and colid=@t
set @str=@str+@tem
set @t=@t+1end;
select @str name
drop table t
A B C
---------- ------------ ----------- (所影响的行数为 0 行)name
-----------------------------
ABC(所影响的行数为 1 行)