T-SQL Select a bunch of data from another DB and Copy to DB2

H all,

Fist of all, thanks for r开发者_如何学运维eading this. My Question is, how can I select a bunch of data from ANOTHER database and insert to my own database with same coloum name and field? I just can think of is using select from DB1 and then insert into DB2. I plan to written this process inside a stored procedures. Is there a better way to do so?

Development enviroment :Sql server 2008 and VS2010(using .net C# to excecute Stored prod) Thank you, Appreciate its lot. And Please don't hesitate to voice out my error or mistake.I wish to learn from mistake

LiangCk

---

You can do the following if its the same database server

INSERT INTO [DB].[UserName].[TableName]
Select * from [DB2].[UserName].[TableName]

• [DB] is the name of database 1
• [DB2] is the name of database 2
• [UserName] is your sql server username (dbo,....)
• [TableName] is, off course, your table

If you have different sql servers you can connect both servers using linked server.

http://msdn.microsoft.com/en-us/library/ff772782.aspx