Trouble with simple DELETE query

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 2008 Forums

Transact-SQL (2008)

Trouble with simple DELETE query

Author

Topic

hdkrus
Starting Member

2 Posts

Posted - 2010-02-03 : 18:37:08

I executed this query from Visual Studio 2008 Team Suite SP1:

DELETE FROM Person
WHERE (Guid IN ('ec393e4d-8394-4579-953c-03f4544500d2', '94fcc85a-53a9-43f5-b355-dcf7dd7be4aa'))

and it throws the following error:

"Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression."

But there's not all, when I run this query with another table and column, it works.

I'm using SQL Server 2008 Express SP1

Thanx a lot

cmdcenter
Starting Member

15 Posts

Posted - 2010-02-04 : 02:34:06

It's very weird. I tested it on a test table and it worked for me.
Could you use [Guid] instead of Guid and see if it makes any difference?

DELETE FROM Person
WHERE ([Guid] IN ('ec393e4d-8394-4579-953c-03f4544500d2', '94fcc85a-53a9-43f5-b355-dcf7dd7be4aa'))

Kristen
Test

22859 Posts

Posted - 2010-02-04 : 02:35:14

Is "Person" a VIEW perhaps?

Alternatively is there a DELETE TRIGGER on the Person Table (or View)?

hdkrus
Starting Member

2 Posts

Posted - 2010-02-04 : 08:58:49

Ok guys, thanx a lot for your answers...

cmdcenter:

Yes, I've tried [Guid] and didn't work. Thanx for your concern.

Kristen:

Person is a table, but as you well said, it have a DELETE TRIGGER. Maybe the error occurs in the trigger code???? I'll check it out. Thanx greatly for your help...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources