mercredi 23 décembre 2015

Not able to view PRINT values in sql

I want to know the value of @NoOfDaysForDelayApproval in a print syntax, but it is not displaying it.

 declare @NoOfDaysForDelayApproval int
    BEGIN select @NoOfDaysForDelayApproval = sum(Total_Days) 
                from XXACL_EMP_DELAY_APPROVAL_V
    where cardno=@EmpCardNo
    and DMonth= @Month
                and DYear = @Year   
                    print 'delayed :- ' + convert(varchar(50), @NoOfDaysForDelayApproval) 
END

even delayed is not getting print.

I am using SQL-server-2005

Aucun commentaire:

Enregistrer un commentaire