邹建救命！！！ 高手相助！ 如何限制SQL2000数据库里面某一个表或者视图的显示函数

Question

5条记录（可能少于5条）加5个空行后取其5条记录，例：
select top 5 * from
(SELECT TOP 5 id,a1,a2,a3 FROM t
union all SELECT top 5 null,null,null,null from sysobjects) t

Answer 1

select top 5 * from view1不知这样是否可以？ 就只取5条记录

Answer 2

SELECT TOP 5 *
FROM ((SELECT dbo.dhsbhsb.dsdm, dbo.dhsbhsb.szdm, dbo.dhsbhsb.jsje, 
              dbo.dhsbhsb.suil, dbo.dhsbhsb.snse, dbo.dhsbhsb.wthm, dbo.dhsbhsb.wszh, 
              dbo.dhsbhsb.sbbh, dbo.dhsbhsb.jnqk, dbo.dhsbhsb.sbrq, dbo.dhsbhsb.smdm, 
              dbo.dhghdjb.dwmc, dbo.dhghdjb.dwdz, dbo.dhghdjb.yhlx, dbo.dhghdjb.cjsd, 
              dbo.dhghdjb.oper, dbo.dhghdjb.jjlx, dbo.dhghdjb.kebe
        FROM dbo.dhghdjb INNER JOIN
              dbo.dhsbhsb ON dbo.dhghdjb.dsdm = dbo.dhsbhsb.dsdm)
      UNION ALL
      (SELECT TOP 5 NULL, NULL, NULL, NULL, NULL
      FROM sysobjects))
你看这个这么些对吗 ？ 风云大哥

Answer 3

SELECT TOP 5 *
FROM (
SELECT dbo.dhsbhsb.dsdm, dbo.dhsbhsb.szdm, dbo.dhsbhsb.jsje, 
      dbo.dhsbhsb.suil, dbo.dhsbhsb.snse, dbo.dhsbhsb.wthm, dbo.dhsbhsb.wszh, 
      dbo.dhsbhsb.sbbh, dbo.dhsbhsb.jnqk, dbo.dhsbhsb.sbrq, dbo.dhsbhsb.smdm, 
      dbo.dhghdjb.dwmc, dbo.dhghdjb.dwdz, dbo.dhghdjb.yhlx, dbo.dhghdjb.cjsd, 
      dbo.dhghdjb.oper, dbo.dhghdjb.jjlx, dbo.dhghdjb.kebe
FROM dbo.dhghdjb INNER JOIN
      dbo.dhsbhsb ON dbo.dhghdjb.dsdm = dbo.dhsbhsb.dsdm
UNION ALL
SELECT TOP 5 NULL, NULL, NULL, NULL, NULL
FROM sysobjects) a