New Questions

Question

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?

Kumar Duvvarapu · Answer

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