TreeView实例

select schid,schname from T_school select * from T_depart select departid,departname from T_depart where substring(departid,1,6)='100000' select * from dbo.T_grade select gradeid,gradename from T_grade where gradeid like '10000002%' select gradeid,gradename from T_grade where gradeid like '10000001%' select gradeid,gradename from T_grade where gradeid like '10000002%' select classid,classname from dbo.T_class where classid like '1000000101%' select stuid,stuname,stusex from T_student where stuid like '100000010102%'