SELECT dbo.sysobjects.xtype, dbo.syscolumns.name, dbo.sysobjects.name AS Expr1,
dbo.syscolumns.colid
FROM dbo.syscolumns INNER JOIN
dbo.sysobjects ON dbo.syscolumns.id = dbo.sysobjects.id
WHERE (dbo.sysobjects.xtype = 'U') And dbo.sysobjects.name ='表名' and dbo.syscolumns.colid=19
dbo.syscolumns.colid
FROM dbo.syscolumns INNER JOIN
dbo.sysobjects ON dbo.syscolumns.id = dbo.sysobjects.id
WHERE (dbo.sysobjects.xtype = 'U') And dbo.sysobjects.name ='表名' and dbo.syscolumns.colid=19
SELECT @str= dbo.syscolumns.name
dbo.syscolumns.colid
FROM dbo.syscolumns INNER JOIN
dbo.sysobjects ON dbo.syscolumns.id = dbo.sysobjects.id
WHERE (dbo.sysobjects.xtype = 'U') And dbo.sysobjects.name ='表名' and dbo.syscolumns.colid=19
Exec('Select '+@str+' From tb')
declare @tablename as varchar(200)
set @tablename=表名
set @s=''
select @s=@s+','+ltrim(rtrim(name)) from
(
select a.name from syscolumns a, sysobjects d
where a.id=d.id and d.name=@tablename
)
A
set @s=stuff(@s,1,1,'')
--print @s
exec('select '+@s+' from '+@tablename+'')
--根据条件可以生成表列,如果指定19,就用top 19,自己想要的列,加个条件既可!
用存储过程可以拼sql剔掉你这个列,但是oracle的sp返回结果集是个问题
如果不想写这个select 字段名 from 这类的语句,可以用工具自动生成啊。
如果不想写这个select 字段名 from 这类的语句,可以用工具自动生成啊。