1. 替代：数 ...触发器功能 1、 允许/限制对表的修改 2、 自动生成派生列,比如自增字段 3、 强制数据一致性 4、 提供审计和日志记录 5、 防止无效的事务处理 6、 启用复杂的业务逻辑 触发器种类 触发器的种类可划分为4种:1.数据操纵语言(DML)触发器、2.替代(INSTEADOF)触发器、3.数据定

2. 代替,而不是：insteadof 代替;而不是 | interfere with 干涉;干预;妨碍;干扰;影响 | involve in 涉及;卷入;陷入;使进入;使连累

3. instead of是什么意思

3. 代替：in the chargeof 由......掌管 | in honourof 为了纪念,为向......表示敬意 |insteadof 代替

4. 替代,而不是：in vain 徒劳,白费力 |insteadof 替代,而不是 | bear...in mind 记住(某事)

I made this cake specially, with brown sugar instead of white.

我特别地以红糖代替白糖做了这个蛋糕。

I gave him advice instead of money.

我给了他忠告，而不是钱。

The economy is shrinking instead of growing.

经济正在萎缩而不是在增长中。

There is a growing tendency for people to work at home instead of in offices.

人们在家里而不是在办公室里工作的趋势日益增长。

We just had soup instead of a full meal.

我们没有吃全餐，只喝了汤。

Now I can walk to work instead of going by car.

现在我可以步行去上班，而不必开车了。

Interfaces describe a set of functionality, or a contract.

接口描述了一系列功能, 或者是约定.

instead of working hard at her lessons, Mary spends her time building a castle in the air.

玛丽不用功读书, 却花时间去幻想.

Jim should get a job instead of lolling around the house all day.

吉姆应该找份工作,不要成天闲在家里.

He philosophises instead of actually doing something.

他不动手实干,却大谈理论.

instead of helping her, his explanation only mixed her up.

他的解释不但没帮她的忙, 反而把她搞糊涂了.

instead of working at her lessons, she spends her time building castles in the air.

她没有努力学习功课而是花费了很多时间空想.

instead of electricity, there were kerosene lanterns.

没有电, 有煤油灯.

Some people refer all the troubles to bad luck instead of lack of ability.

有些人把自己所有的苦恼都归咎于运气不佳,而不认为是缺乏能力.

He got off with only a fine instead of possible imprisonment.

他仅受到罚款而不被监禁.

I was most chagrined when I heard that he had got the job instead of me.

当我听说是他而不是我得到了那份工作时懊恼极了.

instead of opening the gate, we climbed over it.

我们没有开门, 而是从门顶上爬过去的.

Give me this instead of that.

给我这个,不要那个.

They opt for more holiday instead of more pay.

他们选择了延长假期而不是增加工资.

instead of admitting his mistakes , he shifted the blame onto others.

他自己不认错, 还派别人的不是.

The enemy may have recourse to steel instead of poison.

敌人可能用凶器来取代放毒.

Have you been loafing away the whole afternoon instead of getting on with your work?

难道你把一下午都混了过去而没有继续干你的工作?

We went to the Biology class instead of attending the English lesson.

我们去上生物课而不去上英语课.

Small pickling onions can be used instead of sliced ones.

小块腌洋葱可用来替代切片洋葱。

Why couldn he say something original instead of spouting the same old platitudes?

他为什么就不能讲些有新意的话，而不是喋喋不休地说些老生常谈呢？

She put diesel fuel, instead of petrol, into the tank causing the motor to seize up.

她往油箱里加了些柴油而不是汽油，致使发动机发生故障。

We were still playing at war — dropping leaflets instead of bombs.

我们仍然把战争当儿戏——还在丢传单而不是扔炸弹。

But the survey also revealed firms were running down stocks instead of making new products.

但是调查也显示，各公司正在减少库存，而没有生产新的产品。

instead of snacking on crisps and chocolate, nibble on celery or carrot.

不要把薯片和巧克力当零食来吃，要吃些芹菜和胡萝卜。

Next time you have a problem, think about how you can improve the situation instead of dwelling on all the negative aspects.

下次再碰到问题，想想怎样改善局势，而不是一味考虑那些消极的方面。

Water companies should concentrate on reducing waste instead of building new reservoirs.

自来水公司应该集中精力减少水浪费，而不是修建新水库。

instead of sending them to prison, we have set them to work helping the lemon growers.

我们没有把他们送进监狱，而是让他们帮种柠檬的果农干活儿。

instead of going to work thinking that it will be totally boring, try to be positive.

不要一边去上班一边想着工作太无聊，要积极一些。

生意场上

A：I would suggest that you use this materialinsteadof that .
我建议你改用这种替代那种。

B：But that costs more .
可是那样成本较高。

A：But you will get less waste from this .
但可以减少浪费。

B：We‘ll try it once .
那么就试一次看看吧。

Psychological Counseling-(心理咨询)

instead of

A：Oneof my students told me she was very depressed today.
我的一个学生告诉我她今天心情很坏。

instead of的解释

B：Why?
怎么了？

A：Her father is dying.
她的爸爸快死了。

instead of在线翻译

B：Oh, that’s very sad.
哦，真令人难过。

A：Yeah, she’s broken up about it, poor kid.
是呀，她无法承受这件事，真可怜。

B：What did you do?
你怎么做的？

A：I talked to her for a while, but she’s really depressed. So, I made an appointment with the school counselor for her.
我跟她谈了一会儿，但是她还很沮丧。所以，我便为她约了学校的咨询顾问。

instead of在线翻译

B：That’s a good idea. The counselor is a psychologist. He’s better trained to handle these sortsof things.
这个办法不错。顾问是心理学家。对于处理这些事情他受过良好的培训。

A：Yeah, that’s what I told her. I’m glad she’s reaching out for help,insteadof trying to deal with this on her own.
是，我也是这样和她说的。我很高兴她可以求援而不是自己一个人承担了。

instead of

B：Yeah, me too.
是的，我也有同感。

Cable TV-(有线电视)

A：Mom, can we get cable TV or a satellite dish?
妈妈，我们可以装有线电视或者卫星电视吗？

instead of的翻译

B：It costs money, dear. What’s wrong with the regular television stations?
亲爱的，那可很贵呢。一般的电视台有什么不好？

A：The shows are dull and they’re too many advertisements.
这些节目都很没趣，而且广告太多了。

B：Well, you already watch too much TVinsteadof doing your homework, anyway.
哦，你可是光看那么多电视不做作业了。

A：There ’re educational stations too. I could learn while I watched TV.
（卫星电视）也有教育电视台嘛。我可以一边看电视一边学习。

B：Well, that’s true, but you’d probably only watch cartoons and action movies.
哦，那倒是真的。可是你可能只会看卡通片或动作片哦。

A：No I wouldn’t…can’t we get cable? Everybody has cable.
不，我不会的。我们不可以装有线电视吗？家家都有。

B：Well, if everybody jumped off a bridge, would you jump too?
那么，如果人人都跳河，你也跟着跳吗？

instead of

A：Mom!!!! Please. All my friends have had it for years.
妈妈！拜托，我的朋友们几年前就有了。

instead of

B：Get new friends.
那就交一些新朋友。

A：Why are you always so mean?
你为什么总是这么小气？

B：Because you’d end up spoiled rotten if I wasn’t.
如果我不这样的话你肯定会被我宠得不行的。

A：I could help pay for it.
那我也可以出一部分钱嘛。

instead of

B：Let’s see how your grades are this semester, and maybe I’ll talk to your father about it.
我们看看你这个学期考得怎么样，然后我倒可以和你爸爸商量一下。

A：O.K. Thanks, Mom!
好的，谢谢妈妈。