一个小问题

Question

select count(*) from northwind..employees where age>50

Answer 1

更正：
select count(*) from northwind..employees where datediff(year,birthdate,getdate())>50

Answer 2

CREATE PROCEDURE ecount
@count int out
AS
select @count=count(*) from employees where datediff(yy,birthdate,getdate())>50
GO

Answer 3

CREATE PROCEDURE ecount
AS
select count(*) from employees where datediff(yy,birthdate,getdate())>50
GO

Answer 4

create proc 名
as
select count(*) 数量 from northwind..employees where datediff(year,birthdate,getdate())>50

Answer 5

getdate后面跟着的()是什么意思啊

Answer 6

--那是格式
select getDate()

Answer 7

select count(*) 数量 from northwind..employees 
------^^^^^^^^^如果没有的话那它就返回0
where datediff(year,birthdate,getdate())>50

Answer 8

declare @sum int
select @sum=count(*) from 作者表
where datediff(yy,出生日期,getdate())>50
if @sum<>0
   print @sum
else
   print 0