Monday, March 12, 2012

How to link tables using sp in SQL server2000

Hello,
I am using SQL server2000, Can any one help me to link more than four
tables. I am a new user in Sql. Can I use Short Procedure to link these
tables.
SQL Server doesn't have linked tables. SQL Server has linked
servers.
The only guess I have is that you are referring to using
Microsoft Access to link to SQL Server 2000 tables. In
Access, you can link tables programmatically with DAO code
or you can go to File, Get External Data, Link Tables -
setup or select your ODBC source and then you can select
however many tables you want to link.
If you want a procedure to link them, you can search this
Microsoft Access FAQ site - the code is up there somewhere.
-Sue
On Sun, 5 Nov 2006 16:09:25 +0530, "raj" <raj@.raga.com>
wrote:

>Hello,
> I am using SQL server2000, Can any one help me to link more than four
>tables. I am a new user in Sql. Can I use Short Procedure to link these
>tables.
>

No comments:

Post a Comment