Access link table in SQL Server?
I have a table - Parcels - that contains 250,000 records. I have
several databases that need to use this table. In Access I would create
a comon database with the parcels table in it and then link the table to
each of the databases that need to reference it.
How is this linked feature attained in SQL Server 7? Do I create two
databases and then open two connection objects (Dim con As
ADODB.Connection) and reference the tables in stored procedures or
embedded sql using regular - say - inner join syntax?
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL