f



To retrive a table from one database to and another database(same table)

hi
  i have emp table in one database , how to retrieve same table another
database
  through query analizer
                        give code ,,,

0
suryaitha (11)
3/17/2006 9:41:09 AM
comp.databases.ms-sqlserver 14567 articles. 1 followers. janinepelletier (108) is leader. Post Follow

2 Replies
1655 Views

Similar Articles

[PageSpeed] 53

Hi,

use the three part notation:

SELECT * FROM database.owner.Objectname

 (replace owner by schema for SQL2k5)

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

0
Jens1058 (119)
3/17/2006 11:02:02 AM
Hi surya

While the first database is "Current" as would result from:

Use FirstDatabaseName

select * from OtherDatabaseName..Emp
-- 
-Dick Christoph
"surya" <suryaitha@gmail.com> wrote in message 
news:1142588469.061525.268810@u72g2000cwu.googlegroups.com...
> hi
>  i have emp table in one database , how to retrieve same table another
> database
>  through query analizer
>                        give code ,,,
> 


0
dchristo99 (44)
3/17/2006 3:51:44 PM
Reply: