存储过程传出汇总查询数据的问题？

Question

select @CountAll = count(*) from SupplyAndDemandInfo
select @TodayCount = count(*) from SupplyAndDemandInfo 
where datetime = convert(char(4),YEAR (getdate()))+rtrim(convert(char(2),month(getdate())))+rtrim(convert(char(2),day(getdate())))

Answer 1

Create Procedure Temp_SupplyAndDemandInfo_Count
@CountAll int OUTPUT,
@TodayCount int OUTPUT
AS
   select @CountAll = count(*) from SupplyAndDemandInfo
   select @TodayCount = count(*) from SupplyAndDemandInfo 
   where datetime = convert(char(4),YEAR (getdate()))+rtrim(convert(char(2),month(getdate())))+rtrim(convert(char(2),day(getdate())))

Answer 2

Create Procedure Temp_SupplyAndDemandInfo_Count
@CountAll int OUTPUT,
@TodayCount int OUTPUT
AS
set nocount on
begin  
  select @CountAll = count(*) from SupplyAndDemandInfo
   select @TodayCount = count(*) from SupplyAndDemandInfo 
   where [datetime] =convert(char(8),getdate(),112)
end

Answer 3

Create Procedure Temp_SupplyAndDemandInfo_Count
@CountAll int OUTPUT,
@TodayCount int OUTPUT
AS
  select @CountAll = count(*) from SupplyAndDemandInfo
  select @TodayCount = count(*) from SupplyAndDemandInfo 
   where datetime = getdate()

Answer 4

Create Procedure Temp_SupplyAndDemandInfo_Count
@CountAll int OUTPUT,
@TodayCount int OUTPUT
ASbegin
select @CountAll=count(*) from SupplyAndDemandInfo
select @TodayCount=count(*) from SupplyAndDemandInfo
where convert(char(8),getdate(),112)=[datetime]
end