[MSSQL] 특정 단어 개수 확인 하기, null값 삭제하기

특정 단어 개수 확인하기

 

select count(*) from 테이블명 where 필드명 like '%'

select count(*) from school1$ where spart like '%공립%'
select count(*) from school1$ where sname like '%유치원%'
select count(*) from school1$ where saddr like '%남구%'

 

null값 삭제 하기 

delete from school1$ where stel1 is null and stel2 is null and stel3 is null;