May 6, 2012 at 6:14 am
Hi Friends , whever i load data from one table to another table data load
suppose table1 data like id , name ,sal
1 , ravi , 1200
2 , vebal , 1400
3 , gali , 1780
4 , yelo , 4500
and table 2 structure like id, name ,sal
? , ? , ?
? , ? , ?
? , ? , ?
? , ? , ?
Before loading data table 2 data empty.is there any chance whenever i load data from one table to another table
that time table 2 data contain incoorectly.
is it possible to come like this way.that time what happen exactely.
May 7, 2012 at 12:30 am
You get all question marks in table 2?
How do you load the data into table 2?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 7, 2012 at 12:32 am
Hi,
I have tried really hard to understand this question but I can not understand.
Do you have an identity column in either table?
This is how you copy data from one table to the other.
Insert into table2
Select * from table1
Good Luck,
Garry
May 7, 2012 at 12:59 am
asranantha (5/6/2012)
Hi Friends , whever i load data from one table to another table data loadsuppose table1 data like id , name ,sal
1 , ravi , 1200
2 , vebal , 1400
3 , gali , 1780
4 , yelo , 4500
and table 2 structure like id, name ,sal
? , ? , ?
? , ? , ?
? , ? , ?
? , ? , ?
Before loading data table 2 data empty.is there any chance whenever i load data from one table to another table
that time table 2 data contain incoorectly.
is it possible to come like this way.that time what happen exactely.
1. Please post the query you are using to populate the data in table 2
2. Explain what you mean by "data contain incorrectly", sample result from table 2 would be helpfull
Also check the link given in my signature on how to post questions to get faster and the best responses
I am sure you will appreciate the time spent when you get the responses
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply