执行从查询语句中,直接显示出20行记录?

[stevenhzj]

通过一查询语句,返回20行的记录,这20行的记录除个一列数据为某一固定项外,
其他的都为空?表中也没数据?这样的语句怎样写?

[dawugui]

select top 20 id = 1 , col = '' from tb

[dawugui]

select   top   20   id   =   1   ,   col   =   null   from   tb
select   top   20   id   =   1   ,   col   =   ''     from   tb

[-狙击手-]

select top 20 'a' as col1,' ' as col2,....
from sysobjects a ,sysobjects b

[dobear_0922]

表中也没数据?那乌龟的也查不到数据！

[dawugui]

表中也没数据?那乌龟的也查不到数据！

对。

select top 20 id = 1 , col = null from sysobjects a ,sysobjects b select top 20 id = 1 , col = '' from sysobjects a ,sysobjects b

[kk19840210]

select   top   20   id   =   1   ,   col   =null   from  sysobjects

[fa_ge]

select top 20 id=1 ,col='',co2='' from syscolumns