Whats wrong with this? - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Whats wrong with this?

Author

Topic

drastixnz
Starting Member

3 Posts

Posted - 2012-07-23 : 02:58:57

Help!!!!!

insert into work_dbase.mdb.NationalSets select * from estimator
private.mdb.NationalSets;

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2012-07-23 : 08:23:14

Did you get any error? List out required columns instead of *

Madhivanan

Failing to plan is Planning to fail

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2012-07-23 : 09:24:22

yeah -- what's the problem exactly?

Maybe you were trying to do this?


SELECT *
INTO Work_dbase.mdb.NationalSets
FROM private.mdb.NationalSets

Assuming that the Work_dbase.mdb.NationalSets table didn't exist??????

Transact Charlie

Msg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

http://nosqlsolution.blogspot.co.uk/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-07-23 : 10:15:12

quote:
Originally posted by drastixnz

Help!!!!!

insert into work_dbase.mdb.NationalSets select * from estimator
private.mdb.NationalSets;

dont use insert ..select * unless you're sure that structure of table and order of columns with datatype is exactly similar to source table. Also if there're any identity columns in work_dbase.mdb.NationalSets then you need to provide correct column list

I also hope both dbs (work_dbase and estimatorprivate) are in same server.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources