SET NO_BROWSETABLE ON go SET FMTONLY ON SELECT 0 AS TestValue SET FMTONLY OFF go SET NO_BROWSETABLE OFF go SELECT 0 AS TestValue go SET NO_BROWSETABLE ON go SET NO_BROWSETABLE OFF go SELECT S.Enrol_Date,S.Graduate,S.Identity_Card_No,S.Sex,S.Birthday,S.Enrol_Date,S.Native_Place,S.Nation_No,S.Nationality_No,S.Politics,S.Dwelling_Place,S.Message_Address,S.Postalcode,S.Mailcode,S.Hccounts,S.Re,S.Advice_Note,P.Department_No,P.Specialty_No,C.Class_No,S.Charge,S.Clientage,S.Clientage_Unit_No,S.Student_Kind_No,S.Student_Sort_No,S.Residence_Item_No,S.Student_Alter_No,S.Student_Note_No,S.Pin_Yin,S.Wu_Bi,S.Si_Jiao,S.Tong_Ji,S.Hint FROM Student S,Class C,Specialty P WHERE S.Student_No=13198 AND S.Class_No=C.Class_No AND C.Specialty_No=P.Specialty_No go SET NO_BROWSETABLE ON go SET NO_BROWSETABLE OFF go SELECT 0 AS TestValue go SET NO_BROWSETABLE ON go SET NO_BROWSETABLE OFF go SELECT S.Specialty_No,S.Specialty_Name FROM Specialty S,Department D WHERE S.Department_No=D.Department_No AND S.Department_No=11 ORDER BY D.Department_Code,S.Specialty_Codego SET NO_BROWSETABLE ON go SET NO_BROWSETABLE OFF go SELECT 0 AS TestValue go SET NO_BROWSETABLE ON go SET NO_BROWSETABLE OFF go SELECT C.Class_No,C.Class_Name ,S.Specialty_Code,C.Class_Code FROM Class C,Specialty S WHERE C.Specialty_No=S.Specialty_No AND S.Department_No=11 AND C.Specialty_No=24 ORDER BY S.Specialty_Code,C.Class_Codego SET NO_BROWSETABLE ON go SET NO_BROWSETABLE OFF go SELECT 0 AS TestValue go SET NO_BROWSETABLE ON go SET NO_BROWSETABLE OFF go SELECT Student_Contact_Way_No,Student_No,Student_Contact_Way_Name,Student_Contact_Way_ID FROM Student_Contact_Way WHERE Student_No=13198 ORDER BY Student_Contact_Way_Nogo SET NO_BROWSETABLE ON go SET NO_BROWSETABLE OFF go SELECT 0 AS TestValue go SET NO_BROWSETABLE ON go SET NO_BROWSETABLE OFF go SELECT Student_No,Student_Contacter_No,Identity_Card_No,Contacter_Name,Relation,Work_Unit,Telephone,Message_Address,Postalcode FROM Student_Contacter WHERE Student_No=13198 ORDER BY Student_Contacter_Nogo
go
SET FMTONLY ON SELECT 0 AS TestValue
SET FMTONLY OFF
go
SET NO_BROWSETABLE OFF
go
SELECT 0 AS TestValue go
SET NO_BROWSETABLE ON
go
SET NO_BROWSETABLE OFF
go
SELECT
S.Enrol_Date,S.Graduate,S.Identity_Card_No,S.Sex,S.Birthday,S.Enrol_Date,S.Native_Place,S.Nation_No,S.Nationality_No,S.Politics,S.Dwelling_Place,S.Message_Address,S.Postalcode,S.Mailcode,S.Hccounts,S.Re,S.Advice_Note,P.Department_No,P.Specialty_No,C.Class_No,S.Charge,S.Clientage,S.Clientage_Unit_No,S.Student_Kind_No,S.Student_Sort_No,S.Residence_Item_No,S.Student_Alter_No,S.Student_Note_No,S.Pin_Yin,S.Wu_Bi,S.Si_Jiao,S.Tong_Ji,S.Hint
FROM Student S,Class C,Specialty P WHERE S.Student_No=13198 AND S.Class_No=C.Class_No AND C.Specialty_No=P.Specialty_No go
SET NO_BROWSETABLE ON
go
SET NO_BROWSETABLE OFF
go
SELECT 0 AS TestValue go
SET NO_BROWSETABLE ON
go
SET NO_BROWSETABLE OFF
go
SELECT S.Specialty_No,S.Specialty_Name FROM Specialty S,Department D WHERE S.Department_No=D.Department_No AND S.Department_No=11 ORDER BY D.Department_Code,S.Specialty_Codego
SET NO_BROWSETABLE ON
go
SET NO_BROWSETABLE OFF
go
SELECT 0 AS TestValue go
SET NO_BROWSETABLE ON
go
SET NO_BROWSETABLE OFF
go
SELECT C.Class_No,C.Class_Name ,S.Specialty_Code,C.Class_Code FROM Class C,Specialty S WHERE C.Specialty_No=S.Specialty_No AND S.Department_No=11 AND C.Specialty_No=24 ORDER BY S.Specialty_Code,C.Class_Codego
SET NO_BROWSETABLE ON
go
SET NO_BROWSETABLE OFF
go
SELECT 0 AS TestValue go
SET NO_BROWSETABLE ON
go
SET NO_BROWSETABLE OFF
go
SELECT Student_Contact_Way_No,Student_No,Student_Contact_Way_Name,Student_Contact_Way_ID FROM Student_Contact_Way WHERE Student_No=13198 ORDER BY Student_Contact_Way_Nogo
SET NO_BROWSETABLE ON
go
SET NO_BROWSETABLE OFF
go
SELECT 0 AS TestValue go
SET NO_BROWSETABLE ON
go
SET NO_BROWSETABLE OFF
go
SELECT Student_No,Student_Contacter_No,Identity_Card_No,Contacter_Name,Relation,Work_Unit,Telephone,Message_Address,Postalcode FROM Student_Contacter WHERE Student_No=13198 ORDER BY Student_Contacter_Nogo