这样试试
DECLARE @SQL VARCHAR(8000)
SET @SQL = 'SELECT '
SELECT @SQL = @SQL + COLUMN_NAME +',' FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = '表名' AND COLUMN_NAME NOT IN('字段1','字段2')
SET @SQL = LEFT(@SQL, LEN(@SQL) - 1) + ' FROM 表名'
EXEC(@SQL)
DECLARE @SQL VARCHAR(8000)
SET @SQL = 'SELECT '
SELECT @SQL = @SQL + COLUMN_NAME +',' FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = '表名' AND COLUMN_NAME NOT IN('字段1','字段2')
SET @SQL = LEFT(@SQL, LEN(@SQL) - 1) + ' FROM 表名'
EXEC(@SQL)
多谢多谢!!好用好用啊,就是看不大明白,请高手不吝赐教啊!多谢多谢!
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