你用视图呀create view 视图名 as select 你的列名 as 别名 from 你的表名
select col1 as 别名1 from 表
use pubs select au_lname as lastname from authors
如果我想select表1的第一个字段该如何写呢?
完全可以的: select co1 as name1, co2 as name2 from yourtable
select 你的列名1 别名1,你的列名2 别名2 from 你的表
select 你的列名1 别名1,你的列名2 别名2 from 你的表
declare @sql varchar(300) set @sql = 'select ' select top 1 @sql = @sql + A.name from syscolumns as A left join sysobjects as B on A.id = B.id where B.name = 'tablename' order by A.colorder set @sql = @sql + ' from tablename' exec (@sql)
as
select 你的列名 as 别名 from 你的表名
select au_lname as lastname from authors
select co1 as name1, co2 as name2 from yourtable
set @sql = 'select '
select top 1 @sql = @sql + A.name
from syscolumns as A
left join sysobjects as B
on A.id = B.id
where B.name = 'tablename'
order by A.colorder
set @sql = @sql + ' from tablename'
exec (@sql)