当前位置: 代码迷 >> Sql Server >> 问一个初学者有关问题
  详细解决方案

问一个初学者有关问题

热度:79   发布时间:2016-04-27 13:12:09.0
问一个菜鸟问题
有两条SQL语句:
select count(*) as num from dbo.tb
select create_date from sys.objects where object_id=object_id('tb')

显示结果是分开的,现在我希望这样同时显示:
  num create_date
  300 2012-04-15
 
怎么解决呢?
  




------解决方案--------------------
select count(*),(select create_date from sys.objects where object_id=object_id('tb')) as num from dbo.tb

------解决方案--------------------
SQL code
SELECT  COUNT(*) AS num ,        ( SELECT    create_date          FROM      sys.objects          WHERE     object_id = OBJECT_ID('tb')        ) AS 'create_date'FROM    dbo.tbSELECT  create_dateFROM    sys.objectsWHERE   object_id = OBJECT_ID('tb')
------解决方案--------------------
等价的写法,
SQL code
 select b.rowcnt as 'num',a.create_date from sys.objects a inner join sys.sysindexes b on a.[object_id]=b.id and b.indid=1 where a.[object_id]=object_id('tb')
  相关解决方案