Copy data across tables - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Copy data across tables

Author

Topic

satya068
Posting Yak Master

233 Posts

Posted - 2010-09-22 : 06:00:57

Hi,

i am trying to copy data from SALARY table in ARG database to SALARY2table in MRK database in same server.

can you please tell the script to copy the data across.

thanx in advance.

Satya

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-09-22 : 06:10:13

INSERT INTO MRK.dbo.Salary2 (Column1, ...)
SELECT Column1, ...
FROM ARG.dbo.Salary
WHERE ...

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com

satya068
Posting Yak Master

233 Posts

Posted - 2010-09-22 : 06:14:57

script works,
Thanx for ur help.

Satya

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources