کجای این دستور مشکل داره؟
من میخوام مقدار DATEDIFF رو بدست بیارم و بعدش واسش یه شرط بزارم.
ولی گویا شرط اجرا نمیشه.
@DATEDIFF INT=0
as
SELECT DATEDIFF(Minute, date, GETDATE()) AS Minutes From tblajax
If @DATEDIFF > 60
BEGIN
SELECT Id, name, family, age,
(SELECT DATEDIFF(Minute, date, GETDATE()) AS Minutes)
AS Id FROM tblajax
END
ELSE
BEGIN
SELECT Id, name, family, age,
(SELECT DATEDIFF(Second, date, GETDATE()) AS Minutes)
AS Id FROM tblajax
END
