网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

请说出该程序段的功能。

declare @e numeric(5,2)

declare @ c1 int, @ c2 int, @ c3 int, @ c4 int

set @ c1=0; set @ c2 =0; set @ c3=0; set @ c4=0

declare xxx cursor

for select 成绩 from score

open xxx

fetch xxx into @ c

while @'@ fetch_status = 0

begin

if(@c > =90) set @cl =@ e1 +1;

else if( @ c > =70) set @ c2 =@ c2 +1;

else if(@ c> =60) set @ c3 =@ c3 +1;

else set @ c4 = @ c4 + 1

fetch from xxx into @ c

end

close xxx

deallocate xxx

print 优秀生人数:'+sb(@ c1,5);

print食好生人数:'+str(@ c2,5);

print及格生人数:'+str(@ c3,5);

print及格生人数:'+sh(@ c4,5)


参考答案

更多 “ 请说出该程序段的功能。declare @e numeric(5,2)declare @ c1 int, @ c2 int, @ c3 int, @ c4 intset @ c1=0; set @ c2 =0; set @ c3=0; set @ c4=0declare xxx cursorfor select 成绩 from scoreopen xxxfetch xxx into @ cwhile @'@ fetch_status = 0beginif(@c > =90) set @cl =@ e1 +1;else if( @ c > =70) set @ c2 =@ c2 +1;else if(@ c> =60) set @ c3 =@ c3 +1;else set @ c4 = @ c4 + 1fetch from xxx into @ cendclose xxxdeallocate xxxprint 优秀生人数:'+sb(@ c1,5);print食好生人数:'+str(@ c2,5);print及格生人数:'+str(@ c3,5);print及格生人数:'+sh(@ c4,5) ” 相关考题
考题 TableTAB1wascreatedusingthefollowingstatement:CREATETABLEtab1(c1INT,c2INT,c3INT,c4INT,c5INT);IfcolumnC1isuniqueandqueriestypicallyaccesscolumnsC1andC2together,whichstatement(s)willcreateindex(es)thatwillprovideoptimalqueryperformance?()A.CREATEUNIQUEINDEXxtab1ONtab1(c1)include(c2)B.CREATEUNIQUEINDEXxtab1ONtab1(c1);CREATEINDEXxtab2ONtab1(c3)INCLUDE(c2)C.CREATEUNIQUEINDEXxtab1ONtab1(c2,c1)D.CREATEUNIQUEINDEXxtab1ONtab1(c2)INCLUDE(c1)

考题 有以下程序段若要求使P指向一个int型的动态存储单元,在横线处应填入的是A.(int*)B.intC.int*D.(*int)

考题 补体经典途径的激活顺序是 A、C3→C5→C9B、C1→C2→C4→C3→C5→C9C、C1→C4→C2→C3→C5→C9D、C1→C2→C3→C4→C5→C9E、C1→C3→C2→C4→C5→C9

考题 补体经典途径反应的次序是A、C1→C2→C3…→C9 B、C1→C3→C2→C4……→C9 C、C1→C2→C3→C5……→C9 D、C1→C4→C2→C3→C5……→C9 E、C3→C5→C6……→C9

考题 设有表T,现要在该表新增加一个列,列名为:c1,类型为int。下列能实现该功能的语句是()。AALTER TABLE T ADD COLUMN c1 intBALTER TABLE T ADD (c1 int)CALTER TABLE T ADD COLUMN c1DALTER TABLE T ADD c1

考题 声明一个类型为int类型的变量i,并将其复制为10。该过程的正确语句是()A.set @i=10 delcare int iB.declare @i int set @i=10C.declare @i int set i=10D.delclare @int i = 10

考题 声明一个类型为int类型的变量i,并将其赋值为10。该过程的正确语句是()。A.delclare @int i = 10B.set @i=10 delcare int iC.declare @i int set i=10D.declare @i int set @i=10

考题 声明一个整数型的局部变量a的T-SQL语句是:declare () int

考题 3、写出下列程序段的功能 MOV AH,1 INT 21H AND AL,0FH MOV BL,AL MOV AH,1 INT 21H SHL AL,4 AND AL,BL