How to copy table from DB to DB ?

[Eroticus]

How to copy table from DB to DB ?

Thanks !.

[MentaL]

[serend]

SELECT * INTO SRO_VT_SHARD.dbo.Tab_RefNest from SRO_VT_COPY_SHARD.dbo.Tab_RefNest

[FantasiaSRO]

I always use navicat :D best way how to copy, select and drop :)

[Eroticus]

Thanks :) !

[Eroticus]

Omg * *** wrong topic -.- ! Sorry.

[adminsxza]

How to copy table from DB to DB
UP

[serend]

^what u cant read my post above or what ?

[adminsxza]

serend you post is not working for me !

[serend]

LOL

you delete the table from the database you want to insert the table into

eg delete .Tab_RefNest from SRO_VT_SHARD

then run SELECT * INTO SRO_VT_SHARD.dbo.Tab_RefNest from SRO_VT_COPY_SHARD.dbo.Tab_RefNest