關於 drop table意思 ，我們在網路上蒐集到這些相關的討論、資訊與評價

霜降到了！

#霜降
#天氣開始漸冷
#宜潤肺生津

「霜降」即露水凝結為霜而降的意思。踏入秋季最後一個節氣，雖然就南方氣候而言，天氣並未明顯轉冷，但早上及晚上已漸感到涼意，秋風瑟瑟，落葉知秋，地下漸多泛黃的落葉。由於秋燥的影響，身體明顯感到乾燥，嘴唇脫皮或皮膚痕癢等症狀更是常見，這時候就要好好潤肺生津。「肺主皮毛」，適量進食滋陰潤肺的食物，或在辦公室檯頭置一部放濕機，有助改善皮膚乾燥症狀。除此以外，也要習慣帶備一件外套或披肩，以防因捉摸不定轉季天氣而著涼。

溫馨提示：
．水潤汪汪茶為你滋陰潤肺
．手袋中還是多帶備一件外套或披肩以防著涼
．可以喝蜂蜜水，簡單滋潤一下身體，也能暢通大便

Frost’s Descent Solar Term
This solar term is when dew condenses into frost and drop down. As the last solar term of autumn, the weather is not yet cold in southern climate, but it has slowly cooled down in the mornings and evenings. The autumn wind is rustling, and the yellow leaves are gradually falling. Due to the influence of autumn dryness, the body is dry, and symptoms such as peeling of the lips or itching of the skin are more common. At this time, it is necessary to moisten the lungs. Since the lungs affect the skin and hair, it is better to appropriately consume foods that can nourish yin and moisten lungs, or you can place a humidifier on office table to relieve skin dryness symptoms. In addition, you should also get used to keeping a coat or shawl with you to prevent getting cold due to the uncertain weather.

Gentle reminders:
．Our Hydrate herbal tea can help to nourish yin and moisten lungs
．Keep a coat or shawl in your handbag to protect yourself from the cold.
．Drink a cup of honey water to moisten the body and relieve constipation.

#24節氣

Ed Sheeran 的 Mashup終於完成了！呵呵..讓大家久等了不好意思^^~
再次恭喜IsAac Boo ，這首歌就送給你啦！希望你喜歡啦！
當然也謝謝大家那麼踴躍地參與這次的活動~
希望以後可以更多機會跟大家互動互動咯~

Finally done with Ed Sheeran's Mashup！ sorry for the delay hehe ~
This cover is specially for Isaac Boo, congratulations for winning this giveaway !! and I really hope you like it hahah ~
Once again thank you all for taking part in this giveaway ~
Really enjoyed interacting with you guys ~ Definitely more to come in the future!

Lyrics :

The club isn't the best place to find a lover
So the bar is where I go
Me and my friends at the table doing shots
Drinking fast and then we talk slow

And you come over and start up a conversation with just me
And trust me I'll give it a chance now
Take my hand, stop, put Van the Man on the jukebox
And then we start to dance

So honey now (you know i want your love)
Take me into your loving arms (boy lets not talk too much)
Kiss me under the light of a thousand stars ( ooh grab on my waist)
Place your head of my beating heart (although my heart is falling too )
Im thinking bout how

People fall in love in mysterious ways
Maybe just a touch of a hand
Well me I fall in love with you every single day
I just wana tell you I am

So baby now
Take me into you loving arms
Kiss me under the light of a thousand stars (ooh darling )
Place your head on my beating heart
Im thinking out loud

Maybe we found love right where we are

Music arrangement / Editing : Vivien Loh / eMMa
Video Editing : Vivien Loh
Videographer : Bella Chiu
............................................................................................................
Drop by and say Hi ^^
Youtube : https://www.youtube.com/watch?v=FZIM0sFrXVQ
Instagram : https://www.instagram.com/riseandshineviv/

NOT IN/NOT EXISTS/EXCEPT 使用注意事項

#SQL

【SQL Tips】之【 NULL處理技巧，使用NOT IN /NOT EXISTS/EXCEPT】





許多時候，兩個資料表要找出差異值的時候，許多人第一直覺就是使用【NOT IN】，當然大部分時候都不會有狀況，但是碰到NOT IN的子查詢資料值，如果有NULL，就全盤皆輸，意思就是找不出任何差異。這樣在小量資料可以藉由眼力觀察的狀況下，還可以找出這樣寫法NOT IN的危險地方，但是碰到背景程式，或是資料量多的時候，幾乎無法觀察到這樣危險。所以，告訴自己不要再用【NOT IN】去找出兩邊資料差異。
反倒是要使用【NOT EXISTS】寫法，雖然是複雜一點，但是跨越SQL Server與Oracle兩種資料庫，都是可以正常找出兩邊資料差異值，不擔心NOT EXISTS的基礎資料表有NULL值狀況。另外值得一提就是，需多人會直接使用SQL Server的【EXCEPT】與Oracle的【MINUS】方式，要留意再留意，這樣的方式雖然可以找出差異值，但是針對回傳值，會自動進行重複資料列移除。
【SQL Server Code】
if object_id('x') is not null
drop table x
go
--建立比對基礎資料
create table x(a int)
go
insert into x values(1)
insert into x values(1) --注意重複
insert into x values(NULL) --注意NULL
go

if object_id('y') is not null
drop table y
go

--建立簡單比對來源資料
create table y(b int not null)
go

insert into y values(1)
insert into y values(1)
insert into y values(2)
insert into y values(2)
insert into y values(2) --注意三個2

go

--三種找出y資料表中(1,1,2,2,2) 然後不存在於 x資料表中的(1,1,null)
--【預期要回傳三個2】
--第一種 使用NOT IN 注意(子查詢有NULL值)
--無法處理對比資料表有NULL狀況
SELECT b
FROM y
WHERE b NOT IN(SELECT a from x)
GO

--第二種 使用NOT EXISTS 注意(SELECT 需要 JOIN)
--忠實回傳三個2
SELECT b
FROM y
WHERE NOT EXISTS (SELECT * FROM x WHERE x.a = y.b)
GO

--第三種 使用EXCEPT (僅回傳一個2)
SELECT b FROM y
EXCEPT
SELECT a FROM x
GO

【Oracle Code】
drop table x purge;

--建立比對基礎資料
create table x(a int);

insert into x values(1);
insert into x values(1); --注意重複
insert into x values(NULL); --注意NULL

drop table y purge;

--建立簡單比對來源資料
create table y(b int not null);

insert into y values(1);
insert into y values(1);
insert into y values(2);
insert into y values(2);
insert into y values(2); --注意三個2

--三種找出y資料表中(1,1,2,2,2) 然後不存在於 x資料表中的(1,1,null)
--第一種 使用NOT IN 注意(子查詢有NULL值)
--無法處理對比資料表有NULL狀況
SELECT b
FROM y
WHERE b NOT IN(SELECT a from x);
--第二種 使用NOT EXISTS 注意(SELECT 需要 JOIN)
--忠實回傳三個2
SELECT b
FROM y
WHERE NOT EXISTS (SELECT * FROM x WHERE x.a = y.b);
--第三種 使用EXCEPT (僅回傳一個2)
SELECT b FROM y
MINUS
SELECT a FROM x;

Ed Sheeran 的 Mashup終於完成了！呵呵..讓大家久等了不好意思^^~
再次恭喜IsAac Boo ，這首歌就送給你啦！希望你喜歡啦！
當然也謝謝大家那麼踴躍地參與這次的活動~
希望以後可以更多機會跟大家互動互動咯~

Finally done with Ed Sheeran's Mashup！ sorry for the delay hehe ~
This cover is specially for Isaac Boo, congratulations for winning this giveaway !! and I really hope you like it hahah ~
Once again thank you all for taking part in this giveaway ~
Really enjoyed interacting with you guys ~ Definitely more to come in the future!

Lyrics :

The club isn't the best place to find a lover
So the bar is where I go
Me and my friends at the table doing shots
Drinking fast and then we talk slow

And you come over and start up a conversation with just me
And trust me I'll give it a chance now
Take my hand, stop, put Van the Man on the jukebox
And then we start to dance

So honey now (you know i want your love)
Take me into your loving arms (boy lets not talk too much)
Kiss me under the light of a thousand stars ( ooh grab on my waist)
Place your head of my beating heart (although my heart is falling too )
Im thinking bout how

People fall in love in mysterious ways
Maybe just a touch of a hand
Well me I fall in love with you every single day
I just wana tell you I am

So baby now
Take me into you loving arms
Kiss me under the light of a thousand stars (ooh darling )
Place your head on my beating heart
Im thinking out loud

Maybe we found love right where we are

Music arrangement / Editing : Vivien Loh / eMMa
Video Editing : Vivien Loh
Videographer : Bella Chiu
......................................................................................................
Drop by and say Hi ^^
Facebook : https://www.facebook.com/vivienlohyy/
Instagram : https://www.instagram.com/riseandshineviv/