下列程序的执行结果是______。STORE "" TO ASTORE.NULL.TO BSTORE O TO C? ISNULL(A),ISNULL(B),ISNULL(C),EMPTY(A),EMPTY(B),EMPTY?
下列程序的执行结果是______。
STORE "" TO A
STORE.NULL.TO B
STORE 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,YB.STORE1,2ToXC.STORE1ToXYD.STORE1、2ToX