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

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

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

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

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

___________________________________________________________


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

• 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.