SQL Server存储过程空了

I have a SQL Server stored procedure that is not returning any data when I plug in my parameter...

我有一个SQL Server存储过程，当我插入我的参数时没有返回任何数据...

ALTER PROCEDURE dbo.EncumBugSearch 
@year datetime
AS
BEGIN

SET NOCOUNT ON;

    select *
From dbo.BudgetEncumberedTbl as bet
where year(dateadd(month,-3,bet.be_dateposted)) = @year
order by be_dateposted desc

END
GO

This returns nothing, however, when I plug in a number for the parameter (i.e. 2011) then I get the correct results... any ideas?

然而，当我插入参数的数字（即2011）时，我没有返回任何内容，那么我得到了正确的结果......任何想法？

1 个解决方案

#1

Your parameter is a datetime, when it should be an int.

你的参数是一个日期时间，它应该是一个int。