[Help] MsSQL, Importing and Exporting Tables

[OMEGAbuffer]

Yeah, does anyone know how to import or export tables on MsSQL 2005?

 

[rattrap1337]

Re: MsSQL, Importing and Exporting Tables

I can tell you, but it will cost you a fix

 

[spamman]

Re: MsSQL, Importing and Exporting Tables

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

DONE

 

[spamman]

Re: MsSQL, Importing and Exporting Tables

woops, got table and dbname mixed up. swap them.

 

[rattrap1337]

Re: MsSQL, Importing and Exporting Tables

woops, got table and dbname mixed up. swap them.

nooooooooo WHY? I could have gotten a free fix ^^

 

[rattrap1337]

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

 

[OMEGAbuffer]

Re: MsSQL, Importing and Exporting Tables

Thanks, my good man