UPDATE syntax 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 syntax error

Author

Topic

timothymannah
Starting Member

14 Posts

Posted - 2006-04-30 : 21:12:53

Hi all,

Trying to update whole database column of data. The coloumn is called systemMemId and I am trying to get the values from another table so I'm writing a "SELECT" in place of the from value in the SQL Query.

Here it is:

//UPDATE diabey.AllNewMembers(systemMemId)
//SET SELECT diabey.tbMembers.systemMemId
// FROM diabey.AllNewMembers RIGHT OUTER JOIN
// diabey.tbMembers ON diabey.AllNewMembers.MemberId =
// diabey.tbMembers.MemberId

it didn't work so i tried this:

//UPDATE diabey.AllNewMembers(systemMemId)
//SET diabey.AllNewMembers(systemMemId) =
// (SELECT diabey.tbMembers.systemMemId
// FROM diabey.AllNewMembers RIGHT OUTER JOIN
// diabey.tbMembers ON diabey.AllNewMembers.MemberId =
// diabey.tbMembers.MemberId)

SQL Server says there is an error in line one near the ')' but I'm stumped.

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2006-05-01 : 00:17:08

No offense, but that syntax is HORRIBLE. Please read the Books Online sections pertaining to SELECT statements, UPDATE statements, and DELETE statements.
Meanwhile, I think this (untested) code is what you want:

UPDATE	diabey.AllNewMembers
SET	systemMemId = diabey.tbMembers.systemMemId
FROM	diabey.AllNewMembers
	INNER JOIN diabey.tbMembers ON diabey.AllNewMembers.MemberId = diabey.tbMembers.MemberId)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources