I wouldn't want to fall a victim to a nirvana fallacy, but a person who wants to get a knife into a school could throw the knife over the school fence and pick the knife later. No kind of security scanner can really help in this scenario.
A bigger issue for schools, IME, is all the after-hours activities where students have access to the buildings, but there are no scanners being operated. It is easy to bring things in during those times and stash weapons in lockers or other areas. Similarly, it is easier to have an accomplice open a side door to let someone in without being detected during these off hours.
And even if there were scanners it’s pretty easy to hide a knife in football equipment or a tuba or something.