T-Sql Problem

Hot Topic

Managing user-defined properties for report items
how do i empty the transaction log
Bug in Flat File Connection Object: Risky!!!!
Report Deployment Problem on SQL 2005
ADO.NET Please Help ??
MSSQL and .ASP pages
how do I determine how many columns there are in a file?
MDX Queries in SSIS
Very Frustrated
Exporting data from a merge join from one data flow to another

SQL Server

Select multiple values from a dropdown in RS 2000?
Also for Sql server 2000
The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found
XML data sources in SSRS 2005
Reporting Servers - Export to Multiple tabs in Excel
I hate this
SQL express ?
Using SQL results as parameters for Oracle query through SSIS
SQL Server 2005 Express on VISTA
SQL Server 2005 Notification Services and IIS

T-Sql Problem

Hi there, can someone please help me on how will I transfer a record from a table in one database server to another database server with a different table name

Thanks in advance...

Answer this question

T-Sql Problem

  • rash

    add the server as a linked server, then . . .

    insert into ThisServer.ThisDB.ThisOwner.ThisTable select * from ThatServer.ThatDB.ThatOwner.ThatTable



  • T-Sql Problem
Answer this question