SQL 第八章 NO.1

INSERT INTO Student(StudentNo,LoginPwd,StudentName,Sex,GradeId,Phone,[Address],BornDate,Email)
VALUES('s12013020021','zhangsan','张三','男',1,'01062768866','解放路','1991-1-1','zhangsan@126.com')
INSERT INTO Student(StudentNo,LoginPwd,StudentName,Sex,GradeId,Phone,[Address],BornDate,Email)
VALUES('s12013020031','lisi89','李四','男',1,'13812345678','长江路','1996-2-1',null)
INSERT INTO Student(StudentNo,LoginPwd,StudentName,Sex,GradeId,Phone,[Address],BornDate,Email)
VALUES('s12013020041','default','王五','男',1,'13912345678','default','1995-5-3',null)
INSERT INTO Student(StudentNo,LoginPwd,StudentName,Sex,GradeId,Phone,[Address],BornDate,Email)
VALUES('s12013020051','wanglili','王丽丽','女',1,'13112345678','default','1994-6-2','wangll@souhu.com')
INSERT INTO Student(StudentNo,LoginPwd,StudentName,Sex,GradeId,Phone,[Address],BornDate,Email)
VALUES('s12013020061','default','张峰','男',1,'13212345678','defa','1991-8-8',null)

 

 

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [StudentNo]
      ,[LoginPwd]
      ,[StudentName]
      ,[Sex]
      ,[GradeId]
      ,[Phone]
      ,[Address]
      ,[BornDate]
      ,[Email]
  FROM [MySchool].[dbo].[Student]