以下语句创建的触发器是当对表A进行()操作时触发。CREATETRIGGERABCON表AFORINSERT, UPDATE, DELETEAS „„
A. 只是修改
B. 只是插入
C. 只是删除
D. 修改,插入,删除
查看答案
对于下面的存储过程:CREATE PROCEDUREMyp1 @p IntASSELECT St_name, Age FROM Students WHERE Age=@p假如要在Students表中查找年龄是20岁的学生,()可以正确的调用这个存储过程。
A. EXEC Myp1 @p=´20´
B. EXEC Myp1 @p=20
C. EXEC Myp1=´20´
D. EXEC Myp1=20
对SQL Server中的存储过程,下列说法中正确的是:存储过程 ()。
A. 不能有输入参数
B. 没有返回值
C. 可以自动被执行
D. 可以嵌套使用
请默写出软罐头从原料到成品出厂的全部工序,并画出工艺流程图。
Directions: Read the dialogue, and filling the blanks with the following sentences.Waitress: Good morning. Welcome to our restaurant.Mr. Black: Good morning. I’m John Black. _________( 1 )_______________Waitress: John Black? Yes, a table for two, by the window.Mrs. Black: All right.Waitress: This way please. Please be seated.Mr. Black: Thank you very much.Waitress: Not at all. Here is the menu. _________( 2 )______________Mrs. Black: Since I don’t know much about Chinese food, I’d better leave the choice to you. Anything not too oily will do.Mr. Black: OK. Beef shreds with bamboo shoots.Waitress: Beef shreds with bamboo shoots. Large or small?Mr. Black: Small please. Cayenne flavored diced chicken, but don’t make it too spicy. Small too. And bean curd with crab roe. We also want a vegetable dish. ______( 3)__________Waitress: We have green beans, eggplant, bean sprouts, lettuce, etc.Mrs. Black: We’d like seafood-taste eggplant.Waitress: Sure. _________( 4 ) _____________________Mr. Black: Yes, ham and white gourd soup, please.Waitress: What would you like to drink?Mrs. Black: Red wine.Mr. Black: A bottle of red wine.Waitress: Anything else?Mrs. Black: I think that’s it for now. We don’t want to waste anything. If we need anything else, we will let you know.Waitress: OK. __________( 5 )_____________1. May I take your order?2. Would you like any soup?3. I have made a reservation here.4. I'll be back in a moment with your dishes.5. What would you recommend?