Update Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Update Error

Author

Topic

winston
Starting Member

1 Post

Posted - 2004-01-06 : 07:51:05

Hi,

Can anyone throw any light on the following error that I keep recieving when running the following UPDATE script:

UPDATE [Search]
SET fk_myid =
(SELECT myid
FROM [Details]
WHERE [Details].email = [Search].email)
FROM [Search], [Details]

The error that I receive is:

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionCheckForData (CheckforData()).
[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.

Connection Broken

Any help would be appreciated.

Thanks in advance

Winston Carter

raymondpeacock
Constraint Violating Yak Guru

367 Posts

Posted - 2004-01-06 : 08:32:35

Hi

I'm not sure why ODBC is giving you the error it is, perhaps it's the [ and ].

Anyway, why not try a simpler syntax such as

UPDATE Search
SET fk_myid = Details.myid
FROM Details
WHERE Search.email = Details.email

Raymond

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources