单项选择题

下面的( )语句是正确的。
A、CREATE VIEW view_student AS SELECT * INTO #Tmp FROM Student GO
B、CREATE VIEW view_student AS SELECT * FROM Student ORDER BY StudentID GO
C、CREATE VIEW view_student AS SELECT TOP 100 * FROM Student ORDER BY StudentID GO
D、CREATE VIEW view_student AS DECLARE StuID int SET @stuID=10001 SELECT * FROM Student WHERE StudentID=@stuID GO

微信扫码免费搜题