ISO cursor syntax is not allowed in a scalar function - by Dimitri Furman

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 586175 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 8/13/2010 12:39:39 PM
Access Restriction Public


When I try to declare an insensitive cursor in a scalar UDF using the ISO syntax, I get the "Mixing old and new syntax to specify cursor options is not allowed" error. The same syntax works in a stored procedure. Declaring the same cursor using the T-SQL extended syntax in a scalar UDF also works. Is there a reason why the ISO syntax does not work in a UDF?

This reproes on SQL 2005, 2008, and 2008 R2. 
Sign in to post a comment.
Posted by Tobias [MSFT] on 10/3/2010 at 4:36 PM
Hi Dimitri,

Thank you for brining this to our attention. The behavior will be fixed in the next release of SQL Server.

- Tobias, SQL Server Engine