当前需要通过T-SQL语句建立一个V_Student视图,实现学生姓名、学号、性别、班级的列表显示。以下哪个T-SQL语句的实现是正确的?
A.
create view V_Student as select name as 学生姓名,sno as 学号,gender as 性别 from StudentInfo go
B.
create view V_Student as select name as 学生姓名,sno as 学号,gender as 性别,classname as 班级 from StudentInfo go
C.
create table V_Student as select name as 学生姓名,sno as 学号,gender as 性别,classname as 班级 from StudentInfo go
D.
create table V_Student as select name as 学生姓名,sno as 学号,gender as 性别 from StudentInfo