useful web sites and some useful stuff

Live ur Life !

2011-07-22T18:31:00.006+05:30

This is amazing, Randy Pausch-he died of pancreatic cancer in 2008, but wrote a book ‘The last lecture” before then, one of the bestsellers in 2007. What a legacy to leave behind…

In a letter to his wife Jai and his children, Dylan, Logan, and Chloe, he wrote this beautiful "guide to a better life" for his wife and children to follow.
May you be blessed by his insight.

POINTS ON HOW TO IMPROVE YOUR LIFE

Personality:1. Don't compare your life to others'. You have no idea what their journey is all about.
2. Don't have negative thoughts of things you cannot control. Instead invest your energy in the positive present moment
3. Don't over do; keep your limits
4. Don't take yourself so seriously; no one else does
5. Don't waste your precious energy on gossip
6. Dream more while you are awake
7. Envy is a waste of time. You already have all you need..
8. Forget issues of the past. Don't remind your partner of his/her mistakes of the past. That will ruin your present happiness.
9. Life is too short to waste time hating anyone. Don't hate others.
10. Make peace with your past so it won't spoil the present
11. No one is in charge of your happiness except you
12. Realize that life is a school and you are here to learn.
Problems are simply part of the curriculum that appear and fade away like algebra class but the lessons you learn will last a lifetime.
13. Smile and laugh more
14. You don't have to win every argument. Agree to disagree.

Community:15. Call your family often
16. Each day give something good to others
17. Forgive everyone for everything
18. Spend time with people over the age of 70 & under the age of 6
19. Try to make at least three people smile each day
20. What other people think of you is none of your business
21. Your job will not take care of you when you are sick. Your family and friends will. Stay in touch.

Life:22. Put GOD first in anything and everything that you think, say and do. 23. GOD heals everything
24. Do the right things
25. However good or bad a situation is, it will change
26. No matter how you feel, get up, dress up and show up
27. The best is yet to come
28. Get rid of anything that isn't useful, beautiful or joyful
29. When you’re awake alive in the morning, thank GOD for it
30. If you know GOD you will always be happy. So, be happy.

Think Differently

2011-06-15T19:20:00.000+05:30

The pebble and smart thinking

Many years ago in a small Indian village, A farmer had the misfortune of owing a large sum of money to a village moneylender. The Moneylender, who was old and ugly, fancied the farmer's beautiful Daughter. So he proposed a bargain.

He said he would forgo the farmer's debt if he could marry his Daughter. Both the farmer and his daughter were horrified by the Proposal.

So the cunning money-lender suggested that they let Providence decide the matter. He told them that he would put a black Pebble and a white pebble into an empty money bag. Then the girl would have to pick one pebble from the bag.

1) If she picked the black pebble, she would become his wife and her father's debt would be forgiven.

2) If she picked the white pebble she need not marry him and her father's debt would still be forgiven.

3) But if she refused to pick a pebble, her father would be thrown into Jail.

They were standing on a pebble strewn path in the farmer's field. As They talked, the moneylender bent over to pick up two pebbles. As he Picked them up, the sharp-eyed girl noticed that he had picked up two Black pebbles and put them into the bag.

He then asked the girl to pick A pebble from the bag.

Now, imagine that you were standing in the field. What would you have Done if you were the girl? If you had to advise her, what would you Have told her?

Careful analysis would produce three possibilities:

1. The girl should refuse to take a pebble.

2. The girl should show that there were two black pebbles in the bag And expose the money-lender as a cheat.

3. The girl should pick a black pebble and sacrifice herself in order To save her father from his debt and imprisonment.

Take a moment to ponder over the story. The above story is used with The hope that it will make us appreciate the difference between lateral And logical thinking.

The girl's dilemma cannot be solved with Traditional logical thinking. Think of the consequences if she chooses The above logical answers.

What would you recommend to the Girl to do?

Well, here is what she did....

The girl put her hand into the moneybag and drew out a pebble. Without Looking at it, she fumbled and let it fall onto the pebble-strewn path Where it immediately became lost among all the other pebbles.

"Oh, how clumsy of me," she said. "But never mind, if you look into the Bag for the one that is left, you will be able to tell which pebble I Picked."

Since the remaining pebble is black, it must be assumed that she had Picked the white one, and since the money-lender dared not admit his Dishonesty, the girl changed what seemed an impossible situation into an extremely advantageous one.

MORAL OF THE STORY: Most complex problems do have a solution. It's only that we don't Attempt to think.

The last cookie

2011-06-15T19:15:00.000+05:30

A woman was waiting at an airport one night, with several long hours before her flight. She hunted for a book in the airport shops, bought a bag of cookies and found a place to drop.

She was engrossed in her book but happened to see, that the man sitting beside her, as bold as could be. . .grabbed a cookie or two from the bag in between, which she tried to ignore to avoid a scene.

So she munched the cookies and watched the clock, as the gutsy cookie thief diminished her stock. She was getting more irritated as the minutes ticked by, thinking, “If I wasn’t so nice, I would blacken his eye.”

With each cookie she took, he took one too, when only one was left, she wondered what he would do. With a smile on his face, and a nervous laugh, he took the last cookie and broke it in half.

He offered her half, as he ate the other, she snatched it from him and thought… oooh, brother. This guy has some nerve and he’s also rude, why he didn’t even show any gratitude!

She had never known when she had been so galled, and sighed with relief when her flight was called. She gathered her belongings and headed to the gate, refusing to look back at the thieving ingrate.

She boarded the plane, and sank in her seat, then she sought her book, which was almost complete. As she reached in her baggage, she gasped with surprise, there was her bag of cookies, in front of her eyes.

If mine are here, she moaned in despair, the others were his, and he tried to share. Too late to apologize, she realized with grief, that she was the rude one, the ingrate, the thief.

Moral of the story:

There are 4 things we can not recover...

1.The stone after the throw.

2.The word after it's said.

3.The occasion after the loss.

4.The time after its gone.

Best Attitude to take

2011-06-15T19:02:00.000+05:30

A kindergarten teacher has decided to let her class play a game.

The teacher told each child in the class to bring along a plastic bag containing a few potatoes.

Each potato will be given a name of a person that the child hates,

So the number of potatoes that a child will put in his/her plastic bag will depend on the number of people he/she hates.

So when the day came, every child brought some potatoes with the name of the people he/she hated. Some had 2 potatoes; some 3 while some up to 5 potatoes. The teacher then told the children to carry with them the potatoes in the plastic bag wherever they go (even to the toilet) for 1 week.

Days after days passed by, and the children started to complain due to the unpleasant smell let out by the rotten potatoes. Besides, those having 5 potatoes also had to carry heavier bags. After 1 week, the children were relieved because the game had finally ended....

The teacher asked: "How did you feel while carrying the potatoes with you for 1 week?" The children let out their frustrations and started complaining of the trouble that they had to go through having to carry the heavy and smelly potatoes wherever they go.

Then the teacher told them the hidden meaning behind the game. The teacher said: "This is exactly the situation when you carry your hatred for somebody inside your heart. The stench of hatred will contaminate your heart and you will carry it with you wherever you go. If you cannot tolerate the smell of rotten potatoes for just 1 week, can you imagine what is it like to have the stench of hatred in your heart for your lifetime???"

Moral of the story: Throw away any hatred for anyone from your heart so that you will not carry sins for a lifetime. Forgiving others is the best attitude to take!

What Heaven and Hell are like.........

2011-06-15T18:55:00.001+05:30

A holy man was having a conversation with the Lord one day and said, Lord, I would like to know what Heaven and Hell are like.'

The Lord led the holy man to two doors. He opened one of the doors and the holy man looked in. In the middle of the room was a large round table.

In the middle of the table was a large pot of stew which smelled delicious and made the holy man's mouth water.

The people sitting around the table were thin and sickly. They appeared to be famished. They were holding spoons with very long handles that were strapped to their arms and each found it possible to reach into the pot of stew and take a spoonful, but because the handle was longer than their arms, they could not get the spoons back into their mouths.

The holy man shuddered at the sight of their misery and suffering.

The Lord said, 'You have seen Hell.'

They went to the next room and opened the door. It was exactly the same as the first one. There was the large round table with the large pot of stew which made the holy man's mouth water. The people were equipped with the same long-handled spoons, but here the people were well nourished and plump, laughing and talking.

The holy man said, 'I don't understand.'

It is simple' said the Lord, 'it requires but one skill. You see, they have learned to feed each other, while the greedy think only of themselves.'

Moral of the story

Individuals remain individuals, but individuals helping other members grow as a TEAM

The Salt's Pain

2011-06-15T18:52:00.000+05:30

The Salt's Pain

Once an unhappy young man came to an old master and told he was very sad and asked for a solution.

The old Master instructed the unhappy young man to put a handful of salt in a glass of water and then to drink it. "How does it taste?" the Master asked. "Awful," spat the apprentice. The Master chuckled and then asked the young man to take another handful of salt and put it in the lake. The two walked in silence to the nearby lake and when the apprentice swirled his handful of salt into the lake, the old man said, "Now drink from the lake."

As the water dripped down the young man's chin, the Master asked, "How does it taste?" "Good!" remarked the apprentice. "Do you taste the salt?" asked the Master. "No," said the young man.

The Master sat beside this troubled young man, took his hands, and said,

"The pain of life is pure salt; no more, no less. The amount of pain in life remains the same, exactly the same. But the amount we taste the 'pain' depends on the container we put it into. So when you are in pain, the only thing you can do is to enlarge your sense of things ..... Stop being a glass. Become a lake!"

Top 20 Marrige songs

2011-04-10T15:54:00.004+05:30

Song	Movie	Link
Sri Seetaramula Kalyanamu Chuthamu Rarandi	Seetaramula Kalyanam	http://www.youtube.com/watch?v=3A4k2z9oDzk
Bangaru Bomma Raveme	Rakta Sambandam	http://www.youtube.com/watch?v=foBtxVnzkyw
aha naa pellanta oh na pellanta	mayabazar	http://www.youtube.com/watch?v=SrgOgTy7lAg
Taali Kattu Subha Vela	Antu Leni Katha	http://www.youtube.com/watch?v=3Uwn4yogexQ
Maate Mantramu	Seetakoka Chiluka	http://www.youtube.com/watch?v=RjoiGgo_HQY
Pellante Pandillu	Trisulam	http://www.dishant.com/jukebox.php?songid=37839
sri rasthu subhamasthu	Pelli Pustakam	http://www.youtube.com/watch?v=PWFJFOMhpY4
Alanati ramachandrudu	Murari	http://www.youtube.com/watch?v=L_Wh1MQbdSA
Pidikita Talambrala	Annamacharya	http://www.youtube.com/watch?v=0-MZLHnD2SE
sannajAjiki gunnamAviki	MutyAla Pallaki	http://www.chimatamusic.com/playcmd.php?plist=8051
Pellante Noorella Panta	Meena	http://www.hummaa.com/music/song/Pellante+Noorella+Panta/145046#
Aakasa Pandirilo	Sri Rajeshwari Vilas Coffee Club	http://www.youtube.com/watch?v=gWxHKO-uFPM
srilaxmi pelliki chirunavve katnam	justice chowdary	http://www.youtube.com/watch?v=0lY316i5h00&playnext=1&list=PL35A309A7431A1E00
Anuragame Mantramga	Pelli	http://www.in.com/music/track/pelli-songs/anuragame-mantramga-202675.html
muddula janaki	peddarikam	http://www.youtube.com/watch?v=1uYGZ16RB6c
Kalyanam kamaniyam	swathi	http://www.sakhiyaa.com/swati-1983-%E0%B0%B8%E0%B1%8D%E0%B0%B5%E0%B0%BE%E0%B0%A4%E0%B0%BF/
kalyaanam kamaneeyam kalale pandina vaibhogam	Swati 1983	http://www.sakhiyaa.com/swati-1983-%E0%B0%B8%E0%B1%8D%E0%B0%B5%E0%B0%BE%E0%B0%A4%E0%B0%BF/
Pelli Kala Vachesinde	Preminchukundam Raa	http://www.youtube.com/watch?v=DANLdfONOhc
Akasam Digivachi	Nuvu Naaku Nachav	http://www.youtube.com/watch?v=DkmQ98Rm77U
Aidhurojula Pelli	Varudu	http://www.youtube.com/watch?v=reSaH1Z6rjw

A more successful person sees several years ahead, while others sees only tomorrow

2010-12-13T11:35:00.003+05:30

Chuan and Jing joined a wholesale company together just after graduation. Both worked very hard.

After several years, the boss promoted Jing to sales executive but Chuan remained a sales rep. One day Chuan could not take it anymore, tender resignation to the boss and complained the boss did not value hard working staff, but only promoted those who flattered him.

The boss knew that Chuan worked very hard for the years, but in order to help Chuan realise the difference between him and Jing, the boss asked Chuan to do the following. Go and find out anyone selling water melon in the market? Chuan returned and said yes. The boss asked how much per kg? Chuan went back to the market to ask and returned to inform boss the $12 per kg.

Boss told Chuan, I will ask Jing the same question? Jing went, returned and said, boss, only one person selling water melon. $12 per kg, $100 for 10 kg, he has inventory of 340 melons. On the table 58 melons, every melon weighs about 15 kg, bought from the South two days ago, they are fresh and red, good quality.

Chuan was very impressed and realised the difference between himself and Jing. He decided not to resign but to learn from Jing.

My dear friends, A more successful person is more observant, think more and understand in depth. For the same matter, a more successful person sees several years ahead, while you see only tomorrow. The difference between a year and a day is 365 times, how could you win?

Think! How far have you seen ahead in your life? How thoughtful in depth are you?

Let us change our vision and the world will appear accordingly. It is foolish to shape the world, let us shape ourselves first.

2010-12-06T11:33:00.003+05:30

There was a millionaire who was bothered by severe eye pain. He consulted so many physicians and was getting his treatment done. He did not stop consulting galaxy of medical experts; he consumed heavy loads of drugs and underwent hundreds of injections.

But the ache persisted with great vigor than before. At last a monk who was supposed to be an expert in treating such patients was called for by the millionaire. The monk understood his problem and said that for sometime he should concentrate only on green colors and not to fall his eyes on any other colors. The millionaire got together a group of painters and purchased barrels of green color and directed that every object his eye was likely to fall to be painted in green color just as the monk had directed.
When the monk came to visit him after few days, the millionaire’s servants ran with buckets of green paints and poured on him since he was in red dress, lest their master not see any other color and his eye ache would come back.
Hearing this the monk laughed and said “If only you had purchased a pair of green spectacles, worth just a few rupees, you could have saved these walls and trees and pots and all other articles and also could have saved a large share of his fortune. You cannot paint the world green!”
Let us change our vision and the world will appear accordingly. It is foolish to shape the world, let us shape ourselves first.

Types of Sprouts (Molakalu) molakethinchutaku ginjalu

2010-10-16T12:11:00.000+05:30

English	Telugu
Black Beans	Nalla Pessarlu
Alpha Alpha
Cowpeas	Bobarlu
chick peas	senagalu
Millet	Ragulu
Bajra	sajjalu
	Matkailu
horse grams	Ulavalu
sorghum	jonnalu
sesame seeds	nuvvulu
Peanuts	pallilu

Alpha

Cowpeas

chick peas

Sorghum

BlackBeans

Sesame seeds

Peanuts

Millet

Bajra

Horse Grams

sql server 2008 insert data from one database to another database with schema creation for tables

2010-08-12T12:28:00.002+05:30

Step to be followed to generate the scripts for creating the table and load data into that
In below sept check that ScriptData value need to be set to true

Copy your files faster and easier

2010-08-08T12:30:00.000+05:30

TeraCopy is a compact program designed to copy and move files at the maximum possible speed, providing the user with a lot of features:

Copy files faster. TeraCopy uses dynamically adjusted buffers to reduce seek times. Asynchronous copy speeds up file transfer between two physical hard drives.
Pause and resume file transfers. Pause copy process at any time to free up system resources and continue with a single click.
Error recovery. In case of copy error, TeraCopy will try several times and in the worse case just skip the file, not terminating the entire transfer.
Interactive file list. TeraCopy shows failed file transfers and lets you fix the problem and recopy only problem files.
Shell integration. TeraCopy can completely replace Explorer copy and move functions, allowing you work with files as usual.
Full Unicode support.

Download
http://www.ziddu.com/download/7958906/TeraCopyv2.1withSerialwww.dl4all.com.rar.html

Problem may not be with the other one as we always think, could be very much within us..!

2010-07-08T15:05:00.000+05:30

A man feared his wife wasn’t hearing as well as she used to and he thought she might need a hearing aid. Not quite sure how to approach her, he called the family Doctor to discuss the problem. The Doctor told him there is a simple informal test the husband could perform to give the Doctor a better idea about her hearing loss.

Here’s what you do,” said the Doctor, “stand about 40 feet away from her, and in a normal conversational speaking tone see if she hears you. If not, go to 30 feet, then 20 feet, and s o on until you get a response.”

That evening, the wife is in the kitchen cooking dinner, and he was in the den. He says to himself, “I’m about 40 feet away, let’s see what happens.” Then in a normal tone he asks, ‘Honey, what’s for dinner?” No response.

So the husband moves to closer to the kitchen, about 30 feet from his wife and repeats, “Honey, what’s for dinner?” Still no response.

Next he moves into the dining room where he is about 20 feet from his wife and asks, Honey, what’s for dinner?”

Again he gets no response so, He walks up to the kitchen door, about 10 feet away. “Honey, what’s for dinner?” Again there is no response.

So he walks right up behind her. “Honey, what’s for dinner?”

“James, for the FIFTH time I’ve said, CHICKEN!”

Moral: The problem may not be with the other one as we always think, could be very much within us..!

Life is tough but it’s a lot tougher when you are not paying attention

2010-07-08T14:55:00.000+05:30

1st year students of MBBS were attending their 1st anatomy class.

They all gathered around the surgery table with a real dead dog.

The Professor started class by telling two important qualities as a Doctor.

The 1st is that NEVER BE DISGUSTED FOR ANYTHING ABOUT BODY ,

e.g. He inserted his finger in dog's mouth & on drawing back tasted it in his own mouth.

Then he said them to do the same.

The students hesitated for several minutes.

But eventually everyone inserted their fingers in dog's mouth & then tasted it.

When everyone finished, the Professor looked at them and said:

The most important 2nd quality is OBSERVATION , I inserted my Middle finger but tasted the Index finger.

Now learn to pay attention.

Moral:

Life is tough but it’s a lot tougher when you are not paying attention !!!!!

Why should the wedding ring be worn on the fourth finger?

2010-05-25T18:00:00.002+05:30

A BEAUTIFUL EXPLANATION BY THE CHINESE... PLEASE DO IT.
Why should the wedding ring be worn on the fourth finger?

There is a beautiful and convincing explanation given by the Chinese.

Thumb represents your -- Parents

Second (Index) finger represents your Siblings

Middle finger represents your Self

Fourth (Ring) finger represents your Life Partner

& Last (Little) finger represents your Children

Firstly, open your palms (face to face), bend the middle fingers and hold them together - back to back

Secondly, open and hold the remaining three fingers and the thumb - tip to tip

(As shown in the figure Above)

Now, try to Separate your Thumbs (representing the parents)..., they will open, because your parents are not destined to live with you lifelong (Sorry but its the Truth), and have to leave you sooner or later.

Please join your thumbs as before and separate your Index fingers (representing siblings)... ., they will also open, because your brothers and sisters will have their own families and will have to lead their own separate lives.

Now join the Index fingers and separate your Little fingers (representing your children)... ., they will open too, because the children also will get married and settle down on their own some day...

Finally, join your Little fingers, and try to separate your Ring fingers (representing your spouse).

You will be surprised to see that you just CAN NOT ..,

Coz Husband &Wife have to remain together all their lives - through thick and thin.. !!

ISN'T THIS A LOVELY THEORY.. ??

99.95% challenge

2010-04-14T20:34:00.002+05:30

It is a 99.95% challenge that you will have a wrong answer to the question asked in the passage.
Once there was loving couple traveling in a bus in a mountainous area.
They decided to get down at some place. After the couple got down at some place the bus moved on. As the bus moved on, a huge rock fell on the bus from the mountain and crushed the bus to crumbs. Everybody on board was killed.
The couple upon seeing that, said, "We wish we were on that bus" Why do you think they said that?
Scroll down for answer
..
..
..
..
..
..
..
..
..
..
..
Come on think again ......
..
..
..
..
..
..
..
..
...
..
..
..
..
..
..
..
..
..
Come on try it.....
..
..
..
..
..
..
..
..
------------------- Answer !!!! -------------------

If they had remained on the bus instead of deciding to get down, the resulting time delay could have been avoided and the rock would have fallen after the bus had passed ..!!! Think positive in life always and look for opportunities when u can help Others......

Sachin Ramesh Tendulkar the first batsman to score 200 in ODI history

2010-02-24T19:36:00.000+05:30

Sachin Ramesh Tendulkar became the first man ever to hit 200 in a one-day

Sachin Tendulkar has become the first cricketer ever to hit a double-hundred in a one-day international.

Sachin Tendulkar made 200 n.o. off 147 balls, with 25 fours & 3 sixes not out. First batsman ever to make a double-century in a one-dayer.

Watch Cricket online live video streaming

2010-02-24T19:29:00.002+05:30

Watch Cricket online live video streaming
http://livescores.cricketnirvana.com/

Don't Worry be Happy..........

2010-02-18T13:41:00.001+05:30

One day, the father of a very wealthy family took his son on a trip to the country with the express purpose of showing him how poor people live.

They spent a couple of days and nights on the farm of what would be considered a very poor family.

On their return from their trip, the father asked his son, 'How was the

trip?'

'It was great, Dad.'

'Did you see how poor people live?' the father asked.

'Oh yeah,' said the son.

'So, tell me, what did you learn from the trip?' asked the father

The son answered:

'I saw that we have one dog and they had four.

We have a pool that reaches to the middle of our garden and they have a creek that has no end.

We have imported lanterns in our garden and they have the stars at night.

Our patio reaches to the front yard and they have the whole horizon.

We have a small piece of land to live on and they have fields that go beyond our sight.

We have servants who serve us, but they serve others.

We buy our food, but they grow theirs.

We have walls around our property to protect us, they have friends to protect them.'

The boy's father was speechless.

Then his son added, 'Thanks Dad for showing me how poor we are.'

Isn't perspective a wonderful thing?

Makes you wonder what would happen if we all gave thanks for everything we have, instead of worrying about what we don't have.

Appreciate every single thing you have, especially your friends!

'Life is too short and friends are too few.'

Delete Duplicate Records

2010-02-06T19:52:00.003+05:30

___________________________________________________________

CREATE TABLE dbo.car_info
(
Car_Sl_No INT NOT NULL,
CarCompany NVARCHAR (max) NULL,
CarBodyType NVARCHAR (max) NULL,
CarName NVARCHAR (max) NULL,
EngineType NVARCHAR (max) NULL
)
GO
INSERT INTO dbo.car_info (Car_Sl_No, CarCompany, CarBodyType, CarName, EngineType)VALUES (1, 'Maruti ', 'small ', 'Maruti-800 ', 'petrol')
GO
INSERT INTO dbo.car_info (Car_Sl_No, CarCompany, CarBodyType, CarName, EngineType)
VALUES (2, 'Honda ', 'sedan ', 'City ', 'petrol')
GO
INSERT INTO dbo.car_info (Car_Sl_No, CarCompany, CarBodyType, CarName, EngineType)
VALUES (3, 'Maruti ', 'small ', 'Maruti-800 ', 'petrol')
GO
INSERT INTO dbo.car_info (Car_Sl_No, CarCompany, CarBodyType, CarName, EngineType)
VALUES (4, 'Maruti ', 'small ', 'Waganor Duo ', 'petrol')
GO
INSERT INTO dbo.car_info (Car_Sl_No, CarCompany, CarBodyType, CarName, EngineType)
VALUES (5, 'Honda ', 'sedan ', 'City ', 'petrol')
GO
INSERT INTO dbo.car_info (Car_Sl_No, CarCompany, CarBodyType, CarName, EngineType)
VALUES (6, 'TATA ', 'small ', 'indica ', 'diesel')
GO
INSERT INTO dbo.car_info (Car_Sl_No, CarCompany, CarBodyType, CarName, EngineType)
VALUES (7, 'Mahindra ', 'SUV ', 'Scorpio ', 'diesel')
GO
INSERT INTO dbo.car_info (Car_Sl_No, CarCompany, CarBodyType, CarName, EngineType)
VALUES (8, 'TATA ', 'SUV ', 'Sumo ', 'diesel')
GO
INSERT INTO dbo.car_info (Car_Sl_No, CarCompany, CarBodyType, CarName, EngineType)
VALUES (9, 'Maruti ', 'sedan ', 'SX4 ', 'petrol')
GO
INSERT INTO dbo.car_info (Car_Sl_No, CarCompany, CarBodyType, CarName, EngineType)
VALUES (10, 'Maruti ', 'sedan ', 'Swift-Dzire ', 'diesel')
GO
INSERT INTO dbo.car_info (Car_Sl_No, CarCompany, CarBodyType, CarName, EngineType)
VALUES (11, 'TATA ', 'small ', 'Nano ', 'petrol')
GO
______________________________________________________________________________

Delete duplicate records based on the company name only
delete from dbo.car_info
where exists
(select Car_Sl_No from dbo.car_info s
where s.CarCompany = dbo.car_info.CarCompany and s.Car_Sl_No < dbo.car_info.Car_Sl_No)

What is the difference between char,nchar,varchar and nvarchar

2010-02-01T14:59:00.000+05:30

nchar and nvarchar can store Unicode characters.
char and varchar cannot store Unicode characters.
char and nchar are fixed-length which will reserve storage space for number of characters you specify even if you don't use up all that space.
varchar and nvarchar are variable-length which will only use up spaces for the characters you store. It will not reserve storage like char or nchar.

nchar and nvarchar will take up twice as much storage space, so it may be wise to use them only if you need Unicode support.

Effort is important, but knowing where to make an effort makes all the difference!

2010-01-21T20:33:00.002+05:30

A giant ship engine failed. The ship's owners tried one expert after another, but none of them could figure but how to fix the engine.

Then they brought in an old man who had been fixing ships since he was a young. He carried a large bag of tools with him, and when he arrived, he immediately went to work. He inspected the engine very carefully, top to bottom.

Two of the ship's owners were there, watching this man, hoping he would know what to do. After looking things over, the old man reached into his bag and pulled out a small hammer. He gently tapped something. Instantly, the engine lurched into life. He carefully put his hammer away. The engine was fixed!

A week later, the owners received a bill from the old man for ten thousand dollars.

"What?!" the owners exclaimed. "He hardly did anything!"

So they wrote the old man a note saying, "Please send us an itemized bill."

The man sent a bill that read:

Tapping with a hammer...... ......... ........ $ 2.00

Knowing where to tap.......... ......... ...... $ 9, 998.00

Integration Services Videos (SQL Server 2008)

2009-11-29T21:08:00.000+05:30

Use Integration Services videos to accomplish the following goals:

* Learn about the product and component technologies.

* See how to do various tasks.

* Discover related help topics that help you expand your knowledge of Integration Services.

http://technet.microsoft.com/en-us/library/dd299421.aspx

SQL Server How Do I Videos How-To Demos

2009-11-29T16:26:00.001+05:30

Videos Link

http://technet.microsoft.com/hi-in/sqlserver/dd353197%28en-us%29.aspx

How to create a computed column using SQL Server Management Studio?

2009-11-27T20:05:00.001+05:30

How to create a computed column using SQL Server Management Studio?

Take the following steps to create a computed column using SQL Server Management Studio:

Run SQL Server Management Studio from Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.
In the Connect to Server window, click the Connect button.
In the Microsoft SQL Server Management Studio window, double-click the Databases folder.
In the Microsoft SQL Server Management Studio window, double-click the required database. Here, the Axle database is being used.
In the Microsoft SQL Server Management Studio window, double-click the Tables folder.
In the Microsoft SQL Server Management Studio window, right-click the required table and click Modify.
Type the name of the new column. Here, Amount is the new column.
In Column Properties, expand Computed Column Specification. In the Formula box, type the formula. Here, the Price column is multiplied by the Quantity column.
Go to the File menu and click Save Products to save the modifications in the Products table.