Sunday, April 25, 2010

SQL SERVER – Convert Text to Numbers (Integer) – CAST and CONVERT

How to convert text to integer in SQL?
If table column is VARCHAR and has all the numeric values in it, it can be retrieved as Integer using CAST or CONVERT function.

How to use CAST or CONVERT?

SELECT CAST(YourVarcharCol AS INT) FROM Table
SELECT CONVERT(INT, YourVarcharCol) FROM Table

Will CAST or CONVERT thrown an error when column values converted from alpha-numeric characters to numeric?
YES.

Will CAST or CONVERT retrieve only numbers when column values converted from alpha-numeric characters to numeric?
NO.

Saturday, April 17, 2010

مجھے لکھنے کی خواہش ہے

مجھے لکھنے کی خواہش ہے ۔۔۔

مگر لکھا نہیں جاتا
میرے الفاظ دل کی آہنی دیوار سے سر پھوڑتے ہیں
اور انہیں اظہار کا رستہ نہیں ملتا
میری آنکھیں جنھیں دِل میں چھپے جذبات کو اشکوں کی بولی میں
بتا دینے پہ قدرت تھی
وہ اب کچھ بھی نہیں کہتیں

میرے یہ لب !
جو دل کی ان کہی باتوں کو کہنے سے نہ ڈرتے تھے
وہ لب کچھ بھی نہیں کہتے
میرے یہ اُنگلیاں !
جو دل میں چُھپے جذبات کو اظہار کا رستہ بتاتی تھیں
وہ اب کچھ بھی نہیں لکھتیں

میری آنکھیں، یہ لب، یہ اُنگلیاں مجھ سے کہتے ہیں
کہ اب جذبات کو اظہار کا رستہ نہیں دینا
کہ یہ منہ زور ہوتے ہیں
فقط رستے کے ملنے سے
انہیں منزل تلک جانے کی حاجت ہی نہیں رہتی

نئے رستے پہ جاتے ہیں
نئی راہیں بناتے ہیں
مگر پھر واپسی کے سب نشاں یہ بھول جاتے ہیں
انہیں رستہ نہیں دینا
انہیں تم دِل میں رہنے دو !
وگرنہ خوں رُلائیں گے
انہیں رستہ نہیں دینا
انہیں تم دِل میں رہنے دو !
مجھے لکھنے کی خواہش ہے
مگر لکھا نہیں جاتا

Monday, April 12, 2010

Who Do You Think You Are?

Cascada- Who Do You Think You Are? lyrics

Why can I still believe in tomorrow,
when all I have tried was just in vain (just in vain)
Is it worth the fight I couldn't start believing that those feelings
who died could face the pain (could face the pain)

I don't need no diamond rings, alibis no more.

(chorus):

Who do you think you are
cuz once again you broke my heart
I know that love went just too far
its hard to catch a falling star
but now I finally realize, you're a brown eyed angel in disguise
just one step too far so tell me honestly
who do you think you are
(who do you think you are, who do you think you are)

you and I were on our way together
but this life passed by, these days are gone (these days are gone)
all the tears I've cried they taught me nothing lasts forever
I been blind for just too long

cuz I don't need no diamond rings, alibis no more.

(chorus):
Who do you think you are
cuz once again you broke my heart
I know that love went just to far
its hard to catch a falling star
but now I finally realize, you�re a brown eyed angel in disguise
just one step too far so tell me honestly
who do you think you are (who do you think you are)

Sunday, April 11, 2010

Listen To Your Heart...

Listen To Your Heart - Cascada (with lyrics)

Can't Stop The Rain

I Can't Stop The Rain lyrics

How, how am I supposed to feel
When everything surrounding me
Is nothing but a fake disguise
I don't know,
I don't know where I belong
It's time for me to carry on
I'll say goodbye

I can't stop the rain from fallin'
I'm drownin in these tears I cry
Since you left without a warning
I face the dawn with sleepless eyes
No I can't go on
When clouds are pushin' down on me, boy
I can't stop, I can't stop the rain
From fallin

So, tell me where I went wrong
I'm stuck inside a dream long gone
It's hard to reveal the truth
Your love,
Is nothing but a bitter taste
It's better if I walk away,
Away from you

I can't stop the rain from fallin'
Im drownin in these tears I cry
Since you left without a warning
I face the dawn with sleepless eyes
No I can't go on
When clouds are pushin' down on me, boy
I can't stop, I can't stop the rain
From fallin

Cascada - Can't Stop The Rain Lyrics

All day long I can hear people talking out loud
But when you hold me near, you drown out the crowd
Old mr. webster could never define
What�s being said between your heart and mine