chapter3t-sql编程.sql（Chapter3t-sql programming.Sql）.docVIP

chapter3t-sql编程.sql（Chapter3t-sql programming.Sql） USE MySchool GO /*-- hours 1--*/ /*-- case: find Li Wencai and his adjacent school students --*/ /*-- find Li Wencai information --*/ DECLARE @name nvarchar (50) - student name SET, @name=, Li Wencai -- using the SET assignment SELECT, StudentNo, StudentName, BornDate, Address, FROM, Student, WHERE, StudentName = @name /*-- find Li Wencai adjacent school students --*/ DECLARE @StudentNo int -- student number SELECT, @StudentNo=StudentNo, from, Student, WHERE, StudentName=@name -- assign with SELECT SELECT, StudentNo, StudentName, BornDate, Address, FROM, Student, WHERE (StudentNo = @StudentNo+1) or (StudentNo = @StudentNo-1) /*-- case: output server name, version --*/ PRINT server name: + @@SERVERNAME SELECT @@SERVERNAME AS server name PRINTSQL Server version + @@VERSION SELECT @@VERSION ASSQL Server version /*-- case: display the new student record, insert or update @ERROR data --*/ INSERT, INTO, Student (StudentName, StudentNo, LoginPwd, GradeId, BornDate, Sex, IdentityCard) VALUES (` Wu Song , 10011,123456, 1, 1,1980-12-31 If the @@ERROR is greater than 0, it means that the last statement has been executed Print current error number + convert (varchar (5), @@ERROR) UPDATE, Student, SET, BornDate=1970-7-8, WHERE, StudentNo=10011 PRINT current error number:+CONVERT (varchar (5), @@ERROR) GO /*-- case: use local variables display graphics. The character triangle mosaic (line 5) --*/ DECLARE @tag nvarchar (1) SET @tag=. PRINT @tag PRINT @tag+@tag PRINT @tag+@tag+@tag PRINT @tag+@tag+@tag+@tag PRINT @tag+@tag+@tag+@tag+@tag /*-- hours 2--*/ /*-- case: query student ID is 12003 students in June 10, 2009 organized by the Java Logic course exam, Use the Print statement to output the students name and score --*/ DECLARE @NAME varchar (50) - name DECLARE, @Result, decimal (5,2) -- examination results DECLARE @NO int SET @NO = 10000 SELECT @NAME = StudentName, FROM, Student, WHERE, StudentNo=@NO SELEC