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.


1
0
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

Description

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 Microsoft 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