ALTER PROC SP_DAVE
AS
BEGIN

    SET NOCOUNT ON -- << ADD THIS LINE

    update mytable set st = getdate() 
    where  date = getdate();
    if @@rowcount != 0
    begin
        RAISERROR ('No Rows !!',16,1);
        RETURN -1;
    end
    RETURN 0;
END;