Home Dashboard Directory Help
Search

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


Status: 

Closed
 as Fixed Help for as Fixed


1
0
Sign in
to vote
Type: Bug
ID: 586175
Opened: 8/13/2010 12:39:39 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

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.
Details
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
Sign in to post a workaround.