Friday, May 2, 2014

Inspirational quotes Part 1

Leave a Comment

1) Instead of wishing you were someone else ,be proud of who you are. You never know who was looking at you wishing they were you.

2) People who are 'different' are usually the ones who end up making a difference in the world.

3) Don't worry god is always on time, trust him.

4) Don’t you wish people could be like money, so you could hold them up to the sun and see which ones are fake and who are real.

5) It's the hardest times that teach us the most valuable lessons.

6) Did you ever notice, whenever you need your keys the most, that's when they are the hardest to find.

7) Maybe it's not always about trying to fix something broken. Maybe it's about starting over and creating something better.

8) All our dreams can come true ? if we have the courage to pursue them.

9) Wise men learn more from fools than fools from the wise.

10) There is great force hidden in a gentle command.

11) The antidote for fifty enemies is one friend.

12) The ability to convert ideas to things is the secret to outward success

13) Forgiveness is the fragrance that the violet sheds on the heel that has crushed it.

14) I often quote myself. It adds spice to my conversation.

15) No wind favors he who has no destined port.

16) By necessity, by proclivity, and by delight, we all quote.

17) It is not how much we have, but how much we enjoy, that makes happiness.

18) Life itself is a quotation.

19) Hope is not a strategy. Luck is not a factor. Fear is not an option.

20) Don't ever be afraid to take risks, for they make life worth living.

21) A fine quotation is a diamond on the finger of a man of wit, and a pebble in the hand of a fool.

22) A man without a wife is like a vase without flowers.

23) I love quotations because it is a joy to find thoughts one might have,

24) beautifully expressed with much authority by someone recognized wiser than oneself.

25) I wasn't kissing him. I was telling his lips a secret.

26) The next thing to saying a good thing yourself, is to quote one.

27) Maybe part of loving is learning to let go.

28) At times we do not value our belongings. Unless they stop belonging to us.

29) Live your life and forget your age.

30) Happiness comes with a price tag. If you are smiling, you have already paid for it in past.

31) Sometimes, change is what's best. Strength can be measured not by holding on but by letting go.

32) No one invites you to the top – you have to claw your way up.  When you get there, you will sit with the others who were also uninvited – giggling.

33) Don't live down to expectations. Go out there and do something remarkable.

34) Sometimes it takes falling apart to ever have a chance of being fully whole.

35) The greatest blessing granted to mankind come by way of madness, which is a divine gift.

36) The kind of beauty I want most is the hard-to-get kind that comes from within – strength, courage, dignity.

37) Don’t tell me about your god with your words. Show me about your god with your actions.

38) Faith is like radar that sees through the fog — the reality of things at a distance that the human eye cannot see.

39) Il n'y a de réalité que dans l'action.  (There is no reality except in action.)

40) Only when I fall do I get up again.

41) There is a road from the eye to the heart that does not go through the intellect.

42) To accomplish great things, we must dream as well as act.

43) All the time you're saying to yourself, 'I could do that, but I won't,'–which is just another way of saying that you can't.

44) You only get one life. Live it to the fullest. All your miseries will be forgiven when you will be dead.

45) Kecantikan yang abadi terletak pada keelokan adab dan ketinggian ilmu seseorang. Bukan terletak pada wajah dan pakaiannya

46) It is this belief in a power larger than myself and other than myself which allows me to venture into the unknown and even the unknowable.

47) You couldn't erase the past. You couldn't even change it. But sometimes life offered you the opportunity to put it right.

48) Hate looks like everybody else until it smiles

49) Every adversity, every failure, every heartache carries with it the seed of an equal or greater benefit.

50) The atheist staring from his attic window is often nearer to God than the believer caught up in his own false image of God.

51) Lord, be my rock of safety, the stronghold that saves me. For the honor of your name lead me and guide me.

52) We are constantly invited to be who we are.

53) You kick ass Sam. And don't forget it

54) Make today worth remembering.

55) In this country we have no place for hyphenated Americans.

56) Faith, n. Belief without evidence in what is told by one who speaks without knowledge, of things without parallel.

57) If they give you ruled paper, write the other way.

58) Cynicism is what passes for insight when courage is lacking

59) If you have the guts to be yourself, other people'll pay your price.

60) America is too great for small dreams.

61) You know, the mind is a remarkable thing. Just because you  can't see the wound doesn't mean it isn't hurting. It scars all the time, but it heals.

62) Education is experience, and the essence of experience is self-reliance.

63) If I look at the mass I will never act.

64) I've always wanted to be a cat. Warm and domesticated when you want to be, wild when you don't.

65) We can choose to throw stones, to stumble on them, to climb over them, or to build with them.

66) The journey of a thousand miles begins with a single step. Watch your step.

67) Books have a way of finding their way into our lives, usually, right when we need them the most.

68) Let them call me a rebel and welcome. I feel no concern from it. But should I suffer the misery of devils, were I to make a whore of my soul.

69) To ugly ducklings everywhere, Don't worry about those fluffy yellow morons: They'll never get to be swans

70) HASTA LA VICTORIA SIEMPRE

71) Our Age of Anxiety is, in great part, the result of trying to do today’s jobs with yesterday’s tools!

72) Actually, you can be bad at something…but if you love doing it, that will be enough. – August Boatwright

73) The arc of the moral universe is long, but it bends towards justice.

74) The universe is made of stories, not of atoms.

75) To accomplish great things, we must not only act but also dream, not only plan, but also believe!

76) It is during our darkest moments that we must focus to see the light.

77) Every moment of light and dark is a miracle.

78) Everytime I plant a seed,he say kill it before it grow, he say kill it before they grow.

79) …most of the time, all you have is the moment, and the imperfect love of the people around you.

80) Write to please just one person. If you open a window and make love to the world, so to speak, your story will get pneumonia.

81) Behold the turtle. He makes progress only when he sticks his neck out.

82) Love is what carries you, for it is always there, even in the dark, or most in the dark, but shining out at times like gold stitches in a piece of embroidery.

83) Heaven help the roses if the bombs begin to fall

84) A thing worth having is a thing worth cheating for.

85) My life has been full of terrible misfortunes, most of which never happened.

86) We ask ourselves, who am I to be brilliant, gorgeous, handsome, talented and fabulous? Actually, who are you not to be?

87) People would rather believe than know.

88) It had never occurred to me that our lives, which had been so closely interwoven, could unravel with such speed.

89) Real courage is doing the right thing when nobody's looking.  Doing the unpopular thing because it's what you believe, and the heck with everybody.

90) The moment you stop worrying about success is when success will happen.

91) It is impossible to be both selfish and happy

92) And people who don’t dream, who don’t have any kind of imaginative life, they must… they must go nuts. I can’t imagine that.

93) Life is 10 percent what happens to you and ninety percent how you respond to it.

94) The greatest step towards a life of simplicity is to learn to let go.

95) Travel is never a matter of money but of courage

96) Quietly endure, silently suffer and patiently wait.

97) Tough times never last. Tough people do

98) Who would bring light must endure burning.

99) Now I'm told this is life, and pain's just a simple compromise.

100) Buy a pup and your money will buy Love unflinching that cannot lie.

101) We live out our lives as we are meant to live them-with some choice, with some chance, but mostly as a result of the persons we are.

102) I was taught to strive not because there were any guarantees of success but because the act of striving is in itself the only way to keep faith with life.

103) Feel the fear and do it anyway!

104) Beri aku sesuatu yang paling sulit, aku akan belajar!

105) Respect for self is the beginning of cultivating virtue in men and women.

106) Somehow difficulties are easier to endure when you know your dream is waiting for you at the end.

107) In the end, just three things matter:  How well we have lived How well we have loved How well we have learned to let go

108) Feel your emotions, Live true your passions, Keep still your mind.

109) Man is born broken.  He lives by mending.  The grace of God is glue.

110) In the end, it is important to remember that we cannot become what we need to be, by remaining what we are.

111) Trust men and they will be true to you; treat them greatly and they will show themselves great.

112) We have to pray with our eyes on God, not on the difficulties.

113) My faith is big enough to accept all of God's wonders.

114) The truth was a mirror in the hands of God. It fell, and broke into pieces. Everybody took a piece of it, and they looked at it and thought they had the truth.

115) Look beyond yourself..

116) Pray to God, but row towards shore.

117) Love, and do what you will. If you keep silence, do it out of love. If you cry out, do it out of love. If you refrain from punishing, do it out of love.

118) You can only be afraid of what you think you know.

119) Something amazing happens when you're in love and don't give a damn about what day it is anymore.

120) A sail boat that sails backwards can never see the sun rise.

121) We may have all come on different ships, but we're in the same boat now.

122) The most powerful relationship you will ever have is the relationship with yourself.

123) I was good and bad, but never wicked.

124) Happiness is not having what you want, it is wanting what you have.

125) Be confident small immortals. You are not the only voice that all things utter, nor is there eternal silence in the places where you cannot come.

126) You will find, that when you have someone to love, that the face is less important than the brain, and the body is less important than the heart.

127) What I stand for is what I stand on.

128) Life is about becoming more of who you really are….

129) We spend money that we do not have, on things we do not need, to impress people who do not care.

130) I have the nerve to walk my own way, however hard, in my search for reality, rather than climb upon the rattling wagon of wishful illusions.

131) You are better than you think. A-one, a-two a-three.

132) Fear can only grow in darkness. Once you face fear with light, you win.

133) A lot of the conflict you have in your life exists simply because you're not living in alignment; you're not be being true to yourself.

134) Of course, a sign doesn't mean anything unless you know how to interpret it.

135) Love means never having to be apart

136) Never compromise your values.

137) Many people say I'm the best women's soccer player in the world. I don't think so. And because of that, someday I just might be.

138) You are stronger than you know.

139) Knowing is not enough, we must apply. Willing is not enough, we must do.

140) If you give up what you want most for what you think you should want more, you'll end up miserable.

141) I cannot trust a man to control others who cannot control himself.

142) The meaning of life is that it is to be lived, and it is not to be traded and conceptualized and squeezed into a patter of systems.

143) True intimacy with God always brings humility.

144) Accept whatever comes to you woven in the pattern of your destiny, for what could more aptly fit your needs?

145) Respect your efforts, respect yourself. Self-respect leads to self-discipline. When you have both firmly under your belt, that's real power.

146) I am fallen, flawed and imperfect. Yet drenched in the grace and mercy that is found in Jesus Christ, there is strength

147) Life is like a play: it's not the length, but the excellence of the acting that matters.

148) Nothing great will ever be achieved without great men, and men are great only if they are determined to be so.

149) a dog is not considered a good dog because he is a good barker. a man is not considered a good man because he is a good talker.

150) Republicans are for both the man and the dollar, but in case of conflict the man before the dollar.

Read More...

Wednesday, April 23, 2014

Latest Way2sms Desktop Application (client tool) V2

Leave a Comment

Latest Way2sms Desktop Application (client tool) V2

Way2sms is message service between internet to mobile , way2sms sends message to any mobile network.All you need is a valid Indian mobile number.It’s absolutely free service . they charge from their advertisers. Advertiser’s funds for user communication. Way2SMS will not deduct or charge from Mobile users of any network,standard size of 160 characters they allow 140 characters s for user’s message, rest of the characters will be filled with "Sent via WAY2SMS.COM". All you have to do is just enter 10 DIGIT mobile numbers and send SMS. Way2SMS has no official API for their service as yet and going to their website, logging in , clicking on links and sending a message (not to forget closing those annoying pop-up ads !) was too much of work for all. After analysis of way2sms website, this sms application have been developed.this application used to send SMS from way2sms website


Features:
1) No need to login in browser
2) Show Sent history & login history
3) Sends sms faster.

Download Link : Click here

Required tool : .NET Framework 2.0


Read More...

Friday, February 7, 2014

Converting Times Between Time Zones

Leave a Comment

It is becoming increasingly important for any application that works with dates and times to handle differences between time zones. An application can no longer assume that all times can be expressed in the local time, which is the time available from the DateTime structure. For example, a Web page that displays the current time in the eastern part of the United States will lack credibility to a customer in eastern Asia. This topic explains how to convert times from one time zone to another, as well as how to convert DateTimeOffset values that have limited time zone awareness.
   
Coordinated Universal Time (UTC) is a high-precision, atomic time standard. The world’s time zones are expressed as positive or negative offsets from UTC. Thus, UTC provides a kind of time-zone free or time-zone neutral time. The use of UTC time is recommended when a date and time's portability across computers is important. (For details and other best practices using dates and times, see Coding Best Practices Using DateTime in the .NET Framework.) Converting individual time zones to UTC makes time comparisons easy.

VB.NET
Dim dateNow As Date = Date.Now      
Console.WriteLine("The date and time are {0} UTC.",TimeZoneInfo.ConvertTimeToUtc(dateNow))
C#.NET
DateTime dateNow = DateTime.Now;
Console.WriteLine("The date and time are {0} UTC.", TimeZoneInfo.ConvertTimeToUtc(dateNow));
If the date and time value does not represent either the local time or UTC, the ToUniversalTime method will likely return an erroneous result. However, you can use the TimeZoneInfo.ConvertTimeToUtc method to convert the date and time from a specified time zone. (For details on retrieving a TimeZoneInfo object that represents the destination time zone, see Finding the Time Zones Defined on a Local System.) The following code uses the TimeZoneInfo.ConvertTimeToUtc method to convert Eastern Standard Time to UTC.

VB.NET
Dim easternTime As New Date(2007, 01, 02, 12, 16, 00)
Dim easternZoneId As String = "Eastern Standard Time" 
Try 
   Dim easternZone As TimeZoneInfo = TimeZoneInfo.FindSystemTimeZoneById(easternZoneId)
   Console.WriteLine("The date and time are {0} UTC.", TimeZoneInfo.ConvertTimeToUtc(easternTime, easternZone))
Catch e As TimeZoneNotFoundException
   Console.WriteLine("Unable to find the {0} zone in the registry.",easternZoneId)
Catch e As InvalidTimeZoneException
   Console.WriteLine("Registry data on the {0} zone has been corrupted.",easternZoneId)
End Try
C#.NET
DateTime easternTime = new DateTime(2007, 01, 02, 12, 16, 00);
string easternZoneId = "Eastern Standard Time";
try
{
   TimeZoneInfo easternZone = TimeZoneInfo.FindSystemTimeZoneById(easternZoneId);
   Console.WriteLine("The date and time are {0} UTC.",TimeZoneInfo.ConvertTimeToUtc(easternTime, easternZone));
}
catch (TimeZoneNotFoundException)
{
   Console.WriteLine("Unable to find the {0} zone in the registry.",easternZoneId);
}                           
catch (InvalidTimeZoneException)
{
   Console.WriteLine("Registry data on the {0} zone has been corrupted.", easternZoneId);
}

Time Zone IDs (Compact 2013)

The Dynamic Daylight Savings Time (Dynamic DST) feature provides the following time zone IDs.

ID    Time zone name                    Time Difference Display string
0     Dateline Standard Time            (UTC-12:00)  International Date Line West
110   UTC-11                            (UTC-11:00)  Coordinated Universal Time -11
200   Hawaiian Standard Time            (UTC-10:00)  Hawaii
300   Alaskan Standard Time             (UTC-09:00)  Alaska
400   Pacific Standard Time             (UTC-08:00)  Pacific Time (US and Canada)
410   Pacific Standard Time (Mexico)    (UTC-08:00)  Baja California
500   Mountain Standard Time            (UTC-07:00)  Mountain Time (US and Canada)
510   Mountain Standard Time (Mexico)   (UTC-07:00)  Chihuahua, La Paz, Mazatlan
520   US Mountain Standard Time         (UTC-07:00)  Arizona
600   Canada Central Standard Time      (UTC-06:00)  Saskatchewan
610   Central America Standard Time     (UTC-06:00)  Central America
620   Central Standard Time             (UTC-06:00)  Central Time (US and Canada)
630   Central Standard Time (Mexico)    (UTC-06:00)  Guadalajara, Mexico City, Monterrey
700   Eastern Standard Time             (UTC-05:00)  Eastern Time (US and Canada)
710   SA Pacific Standard Time          (UTC-05:00)  Bogota, Lima, Quito
720   US Eastern Standard Time          (UTC-05:00)  Indiana (East)
840   Venezuela Standard Time           (UTC-04:30)  Caracas
800   Atlantic Standard Time            (UTC-04:00)  Atlantic Time (Canada)
810   Central Brazilian Standard Time   (UTC-04:00)  Cuiaba
820   Pacific SA Standard Time          (UTC-04:00)  Santiago
830   SA Western Standard Time          (UTC-04:00)  Georgetown, La Paz, Manaus, San Juan
850   Paraguay Standard Time            (UTC-04:00)  Asuncion
900   Newfoundland Standard Time        (UTC-03:30)  Newfoundland
910   E. South America Standard Time    (UTC-03:00)  Brasilia
920   Greenland Standard Time           (UTC-03:00)  Greenland
930   Montevideo Standard Time          (UTC-03:00)  Montevideo
940   SA Eastern Standard Time          (UTC-03:00)  Cayenne, Fortaleza
950   Argentina Standard Time           (UTC-03:00)  Buenos Aires
1000  Mid-Atlantic Standard Time        (UTC-02:00)  Mid-Atlantic
1010  UTC-2                             (UTC-02:00)  Coordinated Universal Time -02
1100  Azores Standard Time              (UTC-01:00)  Azores
1110  Cape Verde Standard Time          (UTC-01:00)  Cape Verde Is.
1200  GMT Standard Time                 (UTC)        Dublin, Edinburgh, Lisbon, London
1210  Greenwich Standard Time           (UTC)        Monrovia, Reykjavik
1220  Morocco Standard Time             (UTC)        Casablanca
1230  UTC                               (UTC)        Coordinated Universal Time
1300  Central Europe Standard Time      (UTC+01:00)  Belgrade, Bratislava, Budapest, Ljubljana,
1310  Central European Standard Time    (UTC+01:00)  Sarajevo, Skopje, Warsaw, Zagreb
1320  Romance Standard Time             (UTC+01:00)  Brussels, Copenhagen, Madrid, Paris
1330  W. Central Africa Standard Time   (UTC+01:00)  West Central Africa
1340  W. Europe Standard Time           (UTC+01:00)  Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna
1350  Namibia Standard Time             (UTC+01:00)  Windhoek
1400  E. Europe Standard Time           (UTC+02:00)  Minsk
1410  Egypt Standard Time               (UTC+02:00)  Cairo
1420  FLE Standard Time                 (UTC+02:00)  Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius
1430  GTB Standard Time                 (UTC+02:00)  Athens, Bucharest
1440  Israel Standard Time              (UTC+02:00)  Jerusalem
1450  Jordan Standard Time              (UTC+02:00)  Amman
1460  Middle East Standard Time         (UTC+02:00)  Beirut
1470  South Africa Standard Time        (UTC+02:00)  Harare, Pretoria
1480  Syria Standard Time               (UTC+02:00)  Damascus
1490  Turkey Standard Time              (UTC+02:00)  Istanbul
1500  Arab Standard Time                (UTC+03:00)  Kuwait, Riyadh
1510  Arabic Standard Time              (UTC+03:00)  Baghdad
1520  E. Africa Standard Time           (UTC+03:00)  Nairobi
1530  Kaliningrad Standard Time         (UTC+03:00)  Kaliningrad
1550  Iran Standard Time                (UTC+03:30)  Tehran
1540  Russian Standard Time             (UTC+04:00)  Moscow, St. Petersburg, Volgograd
1600  Arabian Standard Time             (UTC+04:00)  Abu Dhabi, Muscat
1610  Azerbaijan Standard Time          (UTC+04:00)  Baku
1620  Caucasus Standard Time            (UTC+04:00)  Yerevan
1640  Georgian Standard Time            (UTC+04:00)  Tbilisi
1650  Mauritius Standard Time           (UTC+04:00)  Port Louis
1630  Afghanistan Standard Time         (UTC+04:30)  Kabul
1710  West Asia Standard Time           (UTC+05:00)  Tashkent
1750  Pakistan Standard Time            (UTC+05:00)  Islamabad, Karachi
1720  India Standard Time               (UTC+05:30)  Chennai, Kolkata, Mumbai, New Delhi
1730  Sri Lanka Standard Time           (UTC+05:30)  Sri Jayawardenepura
1740  Nepal Standard Time               (UTC+05:45)  Kathmandu
1700  Ekaterinburg Standard Time        (UTC+06:00)  Ekaterinburg
1800  Central Asia Standard Time        (UTC+06:00)  Astana
1830  Bangladesh Standard Time          (UTC+06:00)  Dhaka
1820  Myanmar Standard Time             (UTC+06:30)  Yangon (Rangoon)
1810  N. Central Asia Standard Time     (UTC+07:00)  Novosibirsk
1910  SE Asia Standard Time             (UTC+07:00)  Bangkok, Hanoi, Jakarta
1900  North Asia Standard Time          (UTC+08:00)  Krasnoyarsk
2000  China Standard Time               (UTC+08:00)  Beijing, Chongqing, Hong Kong, Urumqi
2020  Singapore Standard Time           (UTC+08:00)  Kuala Lumpur, Singapore
2030  Taipei Standard Time              (UTC+08:00)  Taipei
2040  W. Australia Standard Time        (UTC+08:00)  Perth
2050  Ulaanbaatar Standard Time         (UTC+08:00)  Ulaanbaatar
2010  North Asia East Standard Time     (UTC+09:00)  Irkutsk
2100  Korea Standard Time               (UTC+09:00)  Seoul
2110  Tokyo Standard Time               (UTC+09:00)  Osaka, Sapporo, Tokyo
2130  AUS Central Standard Time         (UTC+09:30)  Darwin
2140  Cen. Australia Standard Time      (UTC+09:30)  Adelaide
2120  Yakutsk Standard Time             (UTC+10:00)  Yakutsk
2200  AUS Eastern Standard Time         (UTC+10:00)  Canberra, Melbourne, Sydney
2210  E. Australia Standard Time        (UTC+10:00)  Brisbane
2220  Tasmania Standard Time            (UTC+10:00)  Hobart
2240  West Pacific Standard Time        (UTC+10:00)  Guam, Port Moresby
2230  Vladivostok Standard Time         (UTC+11:00)  Vladivostok
2300  Central Pacific Standard Time     (UTC+11:00)  Solomon Is., New Caledonia
2310  Magadan Standard Time             (UTC+12:00)  Magadan
2400  Fiji Standard Time                (UTC+12:00)  Fiji
2410  New Zealand Standard Time         (UTC+12:00)  Auckland, Wellington
2430  UTC+12                            (UTC+12:00)  Coordinated Universal Time +12
2500  Tonga Standard Time               (UTC+13:00)  Nuku'alofa
2510  Samoa Standard Time               (UTC-11:00)  Samoa

Read More...

A Visual Explanation of SQL Joins

Leave a Comment

A Visual Explanation of SQL Joins


An SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them.

The most common type of join is SQL INNER JOIN (simple join). An SQL INNER JOIN return all rows from multiple tables where the join condition is met.

Assume we have the following two tables. Table A is on the left, and Table B is on the right. We'll populate them with four records each.
 
id name       id  name
-- ----       --  ----
1  Pirate     1   Rutabaga
2  Monkey     2   Pirate
3  Ninja      3   Darth Vader
4  Spaghetti  4   Ninja
Let's join these tables by the name field in a few different ways and see if we can get a conceptual match to those nifty Venn diagrams.

INNER JOIN

SELECT * FROM TableA
INNER JOIN TableB
ON TableA.name = TableB.name

id  name       id   name
--  ----       --   ----
1   Pirate     2    Pirate
3   Ninja      4    Ninja
Inner join produces only the set of records that match in both Table A and Table B.

FULL OUTER

SELECT * FROM TableA
FULL OUTER JOIN TableB
ON TableA.name = TableB.name

id    name       id    name
--    ----       --    ----
1     Pirate     2     Pirate
2     Monkey     null  null
3     Ninja      4     Ninja
4     Spaghetti  null  null
null  null       1     Rutabaga       
null  null       3     Darth Vader
Full outer join produces the set of all records in Table A and Table B, with matching records from both sides where available. If there is no match, the missing side will contain null.

LEFT OUTER JOIN

SELECT * FROM TableA
LEFT OUTER JOIN TableB
ON TableA.name = TableB.name

id  name       id    name
--  ----       --    ----
1   Pirate     2     Pirate
2   Monkey     null  null
3   Ninja      4     Ninja
4   Spaghetti  null  null
Left outer join produces a complete set of records from Table A, with the matching records (where available) in Table B. If there is no match, the right side will contain null.

LEFT OUTER JOIN

SELECT * FROM TableA
LEFT OUTER JOIN TableB
ON TableA.name = TableB.name
WHERE TableB.id IS null

id  name       id     name
--  ----       --     ----
2   Monkey     null   null
4   Spaghetti  null   null
To produce the set of records only in Table A, but not in Table B, we perform the same left outer join, then exclude the records we don't want from the right side via a where clause.

FULL OUTER JOIN

SELECT * FROM TableA
FULL OUTER JOIN TableB
ON TableA.name = TableB.name
WHERE TableA.id IS null 
OR TableB.id IS null

id    name       id    name
--    ----       --    ----
2     Monkey     null  null
4     Spaghetti  null  null
null  null       1     Rutabaga
null  null       3     Darth Vader
To produce the set of records unique to Table A and Table B, we perform the same full outer join, then exclude the records we don't want from both sides via a where clause.

CROSS JOIN

There's also a cartesian product or cross join, which as far as I can tell, can't be expressed as a Venn diagram:
SELECT * FROM TableA
CROSS JOIN TableB
This joins "everything to everything", resulting in 4 x 4 = 16 rows, far more than we had in the original sets. If you do the math, you can see why this is a very dangerous join to run against large tables.
Read More...

How to create a directory or folder (Microsoft Windows XP, Vista, 7 and 8 )

Leave a Comment
Microsoft XP,7 and 8 users can create a folder several different ways, below is a listing of the different methods to create a folder.

My Computer

  1. Open My Computer or Windows Explorer
  2. Open the drive or folder you wish to create a folder on, for example, the C: drive.
  3. If you do not wish to create a folder in the root directory, browse to the location you wish to create a folder, and then click File, then Folder; or right-click on a blank portion of the folder, click New and click Folder.

New Windows Desktop folderWindows Desktop

  1. Get to the Windows Desktop.
  2. Right-click on any blank portion of the Desktop.
  3. In the menu that appears (like that shown in the picture to the right) click New and the Folder.
  4. A new folder will appear, type the name of the folder you want to use and then press enter.

Windows command line


See the below MS-DOS and Windows command line users section for information about creating a directory in the Windows command line.
MS-DOS and Windows command line users

To create a directory in MS-DOS or the Windows command line use the md or mkdir MS-DOS command. For example, in the below example we are creating a new directory called hope in the current directory.

mkdir hope 

Using Application

This all are long process to create directory or folder.Download small and simple application to create directory or folder.
Click here to download application



Download Link : Click here
Required tool : .NET Framework 2.0

VB.NET code to create directory


My.Computer.FileSystem.CreateDirectory("DirectoryPath")
Or
Imports System.IO

Directory.CreateDirectory("DirectoryPath")

Read More...

Friday, January 31, 2014

Latest Way2sms Desktop Application (client tool)

Leave a Comment

Latest Way2sms Desktop Application (client tool)

Way2sms is message service between internet to mobile , way2sms sends message to any mobile network.All you need is a valid Indian mobile number.It’s absolutely free service . they charge from their advertisers. Advertiser’s funds for user communication. Way2SMS will not deduct or charge from Mobile users of any network,standard size of 160 characters they allow 140 characters s for user’s message, rest of the characters will be filled with "Sent via WAY2SMS.COM". All you have to do is just enter 10 DIGIT mobile numbers and send SMS. Way2SMS has no official API for their service as yet and going to their website, logging in , clicking on links and sending a message (not to forget closing those annoying pop-up ads !) was too much of work for all. After analysis of way2sms website, this sms application have been developed.this application used to send SMS from way2sms website


Features:
1) No need to login in browser
2) Show Sent history & login history
3) Sends sms faster.

Download Link : Click here

Required tool : .NET Framework 2.0


Read More...

Thursday, December 12, 2013

Free Hosting - No Ads or Banners

Leave a Comment

www.hostinger.com

Free Hosting(PHP and MySQL)
2000MB Space, 100GB Traffic
PHP and MySQL, Site Builder
No Ads or Banners

Features : 

New generation of free hosting
Forget bad things and stereotypes about free web hosting. Hostinger is really different. We provide the most reliable and feature rich hosting with fanatic user support! Our service uptime is 99.9%, thanks to the cloud computing technology we utilize.

PHP and MySQL Support
We support PHP and MySQL without any restrictions. Our PHP engine comes with all features and functions enabled. You can switch to any PHP version in one click and manage databases with phpMyAdmin tool.

No ads or banners on your pages
No text links. No unwanted pop-ups. No annoying banners. No mandated forum posting. Your website will be 100 percent ad free forever.

Software auto installer
Just with a few clicks, you can install Wordpress, Joomla, PrestaShop, phpBB, Drupal, and many other necessary scripts. A fully functional and professional looking website can be ready in minutes.

Easy to use website builder
You can now build your site very quickly and easily. Even computer newbies can create a great and nice looking website with our simple website builder! Choose one of 100 ready templates and have your website ready in 5 minutes.

Join our referral program
Invite your friends to join and sign up at Hostinger and get nice gifts such as: MP3 players, LED PowerBalls, USB flash drives, spy cameras, free domain registration, Google android tablets, and much more!

Order Now(India)
Order Now(Other Country)

Read More...