有学生表Student(S# char(8), Sname char(10), Ssex char(2),Sage integer, D# char(2), Sclass char(6))。若要“检索名字为的所有同学姓名”,SQL语句正确的是:
A.
Select Sname From Student Where Sname Like ‘张____’;
B.
Select Sname From Student Where Sname Like ‘张%’;
C.
Select Sname From Student Where Sname Like ‘张_’;
D.
Select Sname From Student Where Sname Not Like ‘张_ _’;