1、3G 一班学生开张重走长征路活动，目的地北京，其中 1 到 40 号为男生，41 到 65 号为女生，男生从广州出发，行程 2100 公里，女生从长沙出发，行程 1100 公里，之后从北京集体回到广州，计算全部学生的总行程。Create database calss3g1On primary ( name=calss3g1_dat,Filename=d:class3g1.mdf,Size=1mb,Maxsize=2mb,Filegrowth=100%)Log on(name=class3g1_log,Filename=d:class3g1.ldf,Size=1mb,Maxsize=2mb)Cr
2、eate table c3g1(SID int,Gender char(2) defaule ,Go_km int )Insert into c3g1Values(1,男,2100)Insert into c3g1Values(40,男 ,2100)Insert into c3g1Values(41,女 ,1100)Insert into c3g1Values(65,女 ,1100)Select sum(go_km)+2100*65 from c3g12,将 ax2 +bx+c=y 作为自变量，与因变量的关系 x 从 0.1 到 0.99，将 x,y,a,b,c 记录在表格 A中Create
3、table A(a int,b int,c int,x float(4),y float(4)Create procedure p_mna int =1,b int=2,c int =3,x float(4)sum:while(x0set c=a/bprint cgoexec p1 a=2,op=/,b=1解法 2create procedure p_aa float,b float,op char(2)asdeclare c floatset c=case opwhen op=+then a+bwhen op=-then a-bwhen op=*then a*bwhen op=/then a
4、/bendgo5 由 1 加到 100，并且不计偶数。create procedure p_sumasdeclare i intset i=1ag:if(i%2=1)and(i1set c=不成立endelse set c=请输入正确的数据范围goreturn cendselect dbo.p(6.4)go9 某线路由 A,B,C,D,E,F,G 各站点组成，A 是起点，G 是终点，求中途站相邻路程。create procedure p_nm asselect identity(int,1,1) as x , S,T into t2 from t1 where SADeclare loop intset loop=1while loop=(select count(x) from t2)Beginselect S,T into RT1 from t1where T=(select T from t2 where x=loop)select S,T into RT2 from t1where S=(select T from t2 where x=loop)select a.S,a.T,b.S,b.T from RT1 a,RT2 bselect loop=loop+1endgoEXEC p_nm
