1. How to join tables from different databases?
2.How to join tables from different servers?
3.How to delete rows which are duplicate?
4.What is the maximum size of the row?
Loading
1. How to join tables from different databases?
2.How to join tables from different servers?
3.How to delete rows which are duplicate?
4.What is the maximum size of the row?
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Kumar DuvvarapuPosted Dec 25, 2007, 2:20 AM
Hi,
Joining two tables in different server
pls refer
http://dotnetslackers.com/SQL/re-22550_SQL_Server_FAQ_How_to_join_tables_from_different_servers.aspx
Joining two tables in different database
select table1.field1, table2.field2
from db1.dbo.tablel1
inner join db2.dbo.table2 on table1.key = table2.key
delete rows which are duplicate
pls refer
http://support.microsoft.com/kb/139444
max row size is 8060 bytes