Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rohan_iiitc
Starting Member
11 Posts |
 Posted - 2010-05-07 : 13:11:43
|
| FriendsI am trying to make a insert querry for a table from one server to other table only for few columns, but i am getting error.1) I want to put only selected column -- not working--Insert into ABC.dbo.TBL_Customer (Col1,Col2,Col3,Col4)Select Col1,Col2,Col3,Col4 from XYZ.dbo.TBL_Customer;Is this the correct way.?Insert into ABC.dbo.TBL_Customer Select Col1,Col2,Col3,Col4 from XYZ.dbo.TBL_Customer;Is working fine.PLease help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-07 : 14:43:02
|
| is any of col1,2,.. in ABC.dbo.TBL_Customer an identity field?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-05-07 : 16:58:12
|
| Yes.The only thing I could think of was, if the columns Col1,Col2,Col3,Col4 were named differently in ABC.dbo.TBL_CustomerEDIT : possibly because of COLLATION differences between the two databases. |
|
|
|
|
|
|
|
|
Insert Into Issue