SQL Server Performance Forum – Threads Archive

Dynamic SQL delete statement not supported err

While trying to update my data through code I am getting the following error "Dynamic SQL delete statement not supported by select statement which doesnt return any key value".Is this a permission issue of database.How to resolve it

Please post the statement you’ve tried to execute. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

Dynamic SQL is more limited in the range of expressions it supports than is static SQL. For example, dynamic SQL does not support subqueries in all the places that they are supported by static SQL. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Satya, can you give an example for this? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

What is the alternative solution for this.or how to trouble shoot this issue

Please post the statement you’re trying to execute. Looks like the error is in that statement. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

]]>