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

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

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

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

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?

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

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

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.

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

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)

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

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?

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:

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

What are the conditions under which a function can be schema bound?

What are the conditions under which a function can be schema bound?

A function can be schema bound only if the following conditions are true:

• The function is a Transact-SQL function.
• The user-defined functions and the views it references are also schema-bound.
• The objects that the function references are referenced using a two-part name.
• The function and the objects it references belong to the same database.
• The user who executed the CREATE FUNCTION statement has REFERENCES permission on the database objects that the function references.
• SCHEMABINDING cannot be specified for functions that reference alias data types or CLR functions.

Waiting for HIKE

Attitude

An old man lived alone in a village.

He wanted to spade his potato garden, but it was very hard work.

His only son, who would have helped him, was in prison.

The old man wrote a letter to his son and mentioned his situation:

Dear Son,

I am feeling pretty bad because it looks like I won't be able to plant my potato garden this year.

I hate to miss doing the garden, because your mother always loved planting time.

I'm just getting too old to be digging up a garden plot.

If you were here, all my troubles would be over.

I know you would dig the plot for me, if you weren't in prison.

Love,

Dad

Shortly the old man received this telegram:

"For Heaven's sake, Dad, don't dig up the garden!! That's where I buried the GUNS!!"

At 4 a.m the next morning, a dozen FBI agents and local police officers showed up and dug up the entire garden without finding any guns.

Confused, the old man wrote another note to his son telling him what happened, and asked him what to do next.

His son's reply was:

"Go ahead and plant your potatoes, Dad.. It's the best I could do for you from here."

Moral:

"NO MATTER WHERE YOU ARE IN THE WORLD,

IF YOU HAVE DECIDED TO DO SOMETHING DEEP FROM YOUR HEART YOU CAN DO IT. IT IS THE THOUGHT THAT MATTERS.. NOT WHERE YOU ARE OR WHERE THE PERSON IS"

TwoOppositeSuicides

Install multiple versions of IE on your PC

Install multiple versions of IE on your PC

Ever wanted to test your website in various versions of Internet Explorer?

Every time you install a newer version of Internet Explorer, Windows has a tendency to overwrite previous versions. And generally, that's a good thing. You're missing out on an awful lot if you're using Internet Explorer 3 to browse the web these days. AJAX, Flash, and other newfangled features just aren't going to work as well, or at all.

But if you're a developer and you want to see how your website looks to someone running an ancient browser, you might want to install an old copy of Internet Explorer alongside your IE7. And it turns out that this is completely doable if a little complicated. You need to alter some settings, redirect some DLLs, and rename a few things here and there.

If you have a PC running Windows XP (it doesn't work for Vista) and you want to test your application in multiple versions of Internet Explorer, you need to install this software.

Install

Source