Linking columns with the table name

Hi Everyone,
Is there a way to read syscolumns and link the column to the table in which
the column resides?
Thanks in advance
Larry
select object_name(id),name from syscolumns
order by object_name(id),colorder
will give you everything in the syscolumns, and the table/sp that it is in.
not sure this is what you want or not.
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:C8FE40BA-274A-4526-B36E-86483D2D683E@.microsoft.com...
> Hi Everyone,
> Is there a way to read syscolumns and link the column to the table in
which
> the column resides?
> Thanks in advance
> Larry
|||Hi Larry
You can look at the code for sp_help to see how that procedure links the
tables together.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:C8FE40BA-274A-4526-B36E-86483D2D683E@.microsoft.com...
> Hi Everyone,
> Is there a way to read syscolumns and link the column to the table in
> which
> the column resides?
> Thanks in advance
> Larry

Linking columns with the table name

Hi Everyone,
Is there a way to read syscolumns and link the column to the table in which
the column resides?
Thanks in advance
Larryselect object_name(id),name from syscolumns
order by object_name(id),colorder
will give you everything in the syscolumns, and the table/sp that it is in.
not sure this is what you want or not.
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:C8FE40BA-274A-4526-B36E-86483D2D683E@.microsoft.com...
> Hi Everyone,
> Is there a way to read syscolumns and link the column to the table in
which
> the column resides?
> Thanks in advance
> Larry|||Hi Larry
You can look at the code for sp_help to see how that procedure links the
tables together.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:C8FE40BA-274A-4526-B36E-86483D2D683E@.microsoft.com...
> Hi Everyone,
> Is there a way to read syscolumns and link the column to the table in
> which
> the column resides?
> Thanks in advance
> Larry

Linking a Excel file to a Table

I have an excel file that I need to copy a column from the file to update a
column in the SQL Table. Is this possible, if so, how I can accomplish this
task?
Thanks in advance
Check out linked servers in the BOL.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:F5C27639-4876-4777-A019-211D06D1A29E@.microsoft.com...
I have an excel file that I need to copy a column from the file to update a
column in the SQL Table. Is this possible, if so, how I can accomplish this
task?
Thanks in advance
sql

Linking a Excel file to a Table

I have an excel file that I need to copy a column from the file to update a
column in the SQL Table. Is this possible, if so, how I can accomplish this
task?
Thanks in advanceCheck out linked servers in the BOL.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:F5C27639-4876-4777-A019-211D06D1A29E@.microsoft.com...
I have an excel file that I need to copy a column from the file to update a
column in the SQL Table. Is this possible, if so, how I can accomplish this
task?
Thanks in advance

Linked table in Access shows wrong data

I am attempting to link two tables from SQL server to an access application. Both contain the same column names and the same fields as concatenated primary key but the tables are named differently, have different values and used differently. When these ta
bles are linked in access, one of the tables changes to a single primary key. When this table is opened, you see many duplicates (of what was the concatenated primary key) but the count of records is still equal to SQL Server. When I query in Access for d
uplicates, no results are returned. I drop the table and re-link it, but it still shows a single key. How can I get Access to accept the true table schema?
"bbitzer" <anonymous@.discussions.microsoft.com> wrote in message
news:0219C2D0-5ADB-48E7-86D0-EAC93D9D5422@.microsoft.com...
> I am attempting to link two tables from SQL server to an access
application. Both contain the same column names and the same fields as
concatenated primary key but the tables are named differently, have
different values and used differently. When these tables are linked in
access, one of the tables changes to a single primary key. When this table
is opened, you see many duplicates (of what was the concatenated primary
key) but the count of records is still equal to SQL Server. When I query in
Access for duplicates, no results are returned. I drop the table and re-link
it, but it still shows a single key. How can I get Access to accept the true
table schema?<
On the surface it sounds like a bug... make sure you update your client with
the latest MDAC and Jet updates. Also, on the tables you mention on SQL
Server, be sure that you have added an additional column of data type
timestamp.
Steve