select b,c,d from table1; 这样是不对的,因为其他三列我并不知道它们的列名是什么,这些对于我来说都是未知的.
得到表中除Col1、Col2的所有列例如:userno_fm、userno_to create table test( num int identity(1,1), userno_fm varchar(10), userno_to varchar(10), username varchar(10)) select * from testdeclare @sql varchar(8000) select @sql='' select @sql=@sql+','+[name] from (select [name] from syscolumns where object_id(N'[test]')=[id] and [name] not in ('userno_fm','userno_to')) A set @sql='select '+stuff(@sql,1,1,'')+' from [test]' --print @sql exec (@sql)drop table test
go
显示除a外的各列
这个意思吗?select b,c,d from table1;
然后
sql1="select "&列1
sql2=sql1&","&列2
sql3=sql2 &","&列3
...
sqln=sqln-1&"from table1"
这样是不对的,因为其他三列我并不知道它们的列名是什么,这些对于我来说都是未知的.
create table test(
num int identity(1,1),
userno_fm varchar(10),
userno_to varchar(10),
username varchar(10))
select * from testdeclare @sql varchar(8000)
select @sql=''
select @sql=@sql+','+[name] from
(select [name] from syscolumns where object_id(N'[test]')=[id] and [name] not in ('userno_fm','userno_to')) A set @sql='select '+stuff(@sql,1,1,'')+' from [test]'
--print @sql
exec (@sql)drop table test