declare @sql varchar(1000)
SET @sql='select '
DECLARE C11 CURSOR FOR
select name from syscolumns where id=
(select max(id) from sysobjects where xtype='u' and name='表名')
and name <> '除外的字段'
OPEN C11
FETCH NEXT FROM C11 INTO
@name
IF @@FETCH_STATUS <> 0
BEGIN
DEALLOCATE C11
RETURN
END
WHILE(@@FETCH_STATUS = 0)
BEGIN
SET @sql=@sql+@name+','
FETCH NEXT FROM C11 INTO
@name
END
DEALLOCATE C11
set @sql=substring(@sql,1,len(@sql)-1)+' from 表名'
exec (@sql)
匿名回答于2024-05-24 02:57:21