Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Help] MsSQL, Importing and Exporting Tables

Experienced Elementalist
Joined
Jan 3, 2008
Messages
299
Reaction score
1
Yeah, does anyone know how to import or export tables on MsSQL 2005?
 
Last edited by a moderator:
Initiate Mage
Joined
Jun 20, 2008
Messages
57
Reaction score
0
Re: MsSQL, Importing and Exporting Tables

I can tell you, but it will cost you a fix :)
 
Junior Spellweaver
Joined
Jun 5, 2006
Messages
133
Reaction score
0
Re: MsSQL, Importing and Exporting Tables

select * into newtable.dbo.dbname from tablename.dbo.dbname

DONE
 
Junior Spellweaver
Joined
Jun 5, 2006
Messages
133
Reaction score
0
Re: MsSQL, Importing and Exporting Tables

woops, got table and dbname mixed up. swap them.
 
Initiate Mage
Joined
Jun 20, 2008
Messages
57
Reaction score
0
Re: MsSQL, Importing and Exporting Tables

Might as well tell him that he needs to create 2 more databases as well, one to hold the original table, and the other to hold the table that needs to be imported
 
Experienced Elementalist
Joined
Jan 3, 2008
Messages
299
Reaction score
1
Re: MsSQL, Importing and Exporting Tables

Thanks, my good man
 
Back
Top