nice question ;

one more observation :

-- t1(id int,data varchar(50)) ; t6 table doesn't exist

create procedure usp_testing

as

select a.id,a.testing from t1 a

inner join t6 b

on b.id = a.id

go

this doesn't throw any error either, although column doesn't exist in the t1.