XiaoLian

1. Money talks.      金錢萬能 2. Mind your own business.      少管閒事 3. Many happy returns of the day!      敬祝長命百歲 4. No cross, no crown.      吃得苦中苦，方為人上人 5. Never too old to learn.      活到老學到老 6. No pains, no gains.      不勞無獲 7. Nothing ventured, nothing gained.      不入虎穴焉得虎子 8. Nothing is difficult to a man who wills.      天下無難事，只怕有心人 9. One wrong step may give you a great fall.      一失足成千古恨 10. One sows, another reaps.      前人種樹，後人乘涼

1. Let bygones be bygones.      既往不究 2. Love me, love my dog.      愛屋及烏 3. Lost time is never found again.      光陰一去不回頭 4. Live and learn.      學無止境 5. Learning without thinking is vain; thinking without learning is perilous.      學而不思則罔；思而不學則殆 6. Make hay while the sun shines.      未雨綢繆 7. Money makes the mare go.      金錢能使鬼推磨 8. Man is the lord of creation.      人為萬物之靈 9. My life is limited while knowledge is limitless.      吾生也有涯而知也無涯 10. More haste, less speed.      欲速則不達

1. Harm watch, harm catch.      Harm set, harm get.      害人反害己 2. It is easier to know how to do a thing than to do it.      知易行難 3. It is no use crying over spilt milk.      覆水難收 4. It is more blessed to give than to receive.      施比受更有福 5. It is never too late to mend.      亡羊補牢，猶未為晚 6. Kill two birds with one stone.      一箭雙鵰；一舉二得 7. Keep your mouth shut and your eyes open.      多觀察，少說話 8. Look before you leap.      三思而行 9. Like father, like son.      有其父必有其子 10. Life is evanescent like the morning dew.      人生如朝露

1. Go through fire and water.      赴湯蹈火 2. Good medicine is bitter in the mouth.      良藥苦口 3. Good mind, good find.      善有善報 4. Haste makes waste.      欲速則不達 5. Honesty is the best policy.      誠實為上策 6. His bread is buttered on both sides.      左右逢源 7. Honest advice is unpleasant to the ear.      忠言逆耳 8. History repeats itself.      歷史重演 9. Habit is second nature.      習慣成自然 10. Hunger is the best sauce.      饑不擇食

trigger名稱叫： del_rdr1_record deleted  --->  表示RDR1被delete的那些記錄 當RDR1 table中record del 時 也會更新其它table相對應的record值 完整： ALTER TRIGGER [dbo].[del_rdr1_record]    ON   [dbo].[RDR1]    AFTER DELETE AS BEGIN  SET NOCOUNT ON;       Begin         -- delete RDR1 table中record時觸發並會執行下面的動作     declare @OpenCreQty float         select @OpenCreQty= ISNULL ( sum (OpenCreQty),0) from rdr1  where ItemCode in ( select ItemCode from deleted) and WhsCode in ( select WhsCode from deleted)         --做更新動作 oitm oitw 兩個Table         update oitm set U_Total_SD=@OpenCreQty where ItemCode in ( select ItemCode from deleted)         update oitw set u_sales_demand=@OpenCreQty where ItemCode in ( select ItemCode from deleted) and WhsCode i...

trigger名稱叫： trigger_delete_tmp1 delete tmp1 table中record時觸發並會執行下面的動作 delete from tmp2 where people_id in (select people_id from deleted) deleted  --->  表示tmp1被delete的那些記錄 當tmp1 table中record del 時 也會刪除相對應的 tmp2 table中record 完整： ALTER trigger [dbo].[trigger_delete_tmp1] on [dbo].[tmp1] after delete as Begin  SET NOCOUNT ON;  Begin    delete from tmp2 where people_id in ( select people_id from deleted)   End End