Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Post
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
3
Reply
Copy data from source table to target table
Saurabh H
8 years ago
253
Reply
I have two tables source and destination with same table schema in two different databases. Only data is different.
Write a script to copy data from source to target. Id is a Primary Key. There should be no duplication of Id.
TargetTable
Id Prouct Rate
1 Tea 10
2 Coffee 20
3 Milk 30
SourceTable
Id Prouct Rate
1 Sugar 25
2 Salt 15
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
What is Query cost ? what is it use?
How to use join on stored procedure?