网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
下列程序的执行结果是______。
STORE "" TO A
STORE.NULL.TO B
STORE O TO C
? ISNULL(A),ISNULL(B),ISNULL(C),EMPTY(A),EMPTY(B),EMPTY?
参考答案
更多 “ 下列程序的执行结果是______。STORE "" TO ASTORE.NULL.TO BSTORE O TO C? ISNULL(A),ISNULL(B),ISNULL(C),EMPTY(A),EMPTY(B),EMPTY? ” 相关考题
考题
Youworkforacompanythatsellsbooks.YouarecreatingareportforaSQLServer2005database.Thereportwilllistsalesrepresentativesandtheirtotalsalesforthecurrentmonth.Thereportmustincludeonlythosesalesrepresentativeswhomettheirsalesquotaforthecurrentmonth.Themonthlysalesquotais$2,000.Thedateparametersarepassedinvariablesnamed@FromDateand@ToDate.Youneedtocreatethereportsothatitmeetstheserequirements.WhichSQLqueryshouldyouuse?()A.SELECTs.AgentName,SUM(ISNULL(o.OrderTotal,0.00))ASSumOrderTotalFROM SalesAgentsJOINOrderHeaderoONs.AgentID=o.AgentIDWHEREo.OrderDateBETWEEN@FromDateAND@ToDateGROUPBYs.AgentNameB.SELECTs.AgentName,SUM(ISNULL(o.OrderTotal,0.00))ASSumOrderTotalFROMSalesAgentsJOINOrderHeaderoONs.AgentID=o.AgentIDWHEREo.OrderDateBETWEEN@FromDateAND@ToDateANDo.OrderTotal=2000GROUPBYs.AgentNameC.SELECTs.AgentName,SUM(ISNULL(o.OrderTotal,0.00))ASSumOrderTotalFROMSalesAgentsJOINOrderHeaderoONs.AgentID=o.AgentIDWHEREo.OrderDateBETWEEN@FromDate AND@ToDateGROUPBYs.AgentNameHAVINGSUM(o.OrderTotal)=2000D.SELECTs.AgentName,SUM(ISNULL(o.OrderTotal,0.00))ASSumOrderTotalFROMSalesAgentsJOINOrderHeaderoONs.AgentID=o.AgentIDWHEREo.ordertotal=2000ANDo.OrderDateBETWEEN@FromDateAND@ToDateGROUPBYs.AgentNameHAVINGSUM(o.OrderTotal)=2000
考题
执行下列命令,正确的输出结果是( )。 STORE—123.456 TO NUM?”NUM=”+STR(NUM,8,3)A.123.456SXB
执行下列命令,正确的输出结果是( )。 STORE—123.456 TO NUM?”NUM=”+STR(NUM,8,3)A.123.456B.—123.456C.NUM=—123.456D.NUM=123.456
考题
执行下列命令后,最后一条命令输出的结果是______。STORE"?"TO A1STORE"S"TO A2 STORE 200 TO A2 ?A1.A2A.200SB.200C.?200SD.?S
考题
下列赋值语句中正确的是A.STORE1ToX,Y
B.STORE1,2ToX
C.STORE1ToXY
D.STORE1、2ToX
热门标签
最新试卷