What are the challenges you face when working across database platforms? Take the survey
Options

Bug in rename alias within a stored proc if select list calls a function

jbrunejbrune Posts: 13 Bronze 1
A bug that's a bit tough to find. The Rename Alias / Variable (F2) functionality does not work if there is a function in the select list and it's with a proc.

For example:
CREATE PROCEDURE dbo.MyProc
AS
BEGIN
    SELECT
        CommonModule.MyFunction(),
        _MyT.MyColumn
    FROM
        MyTable _MyT

END

You won't be able to Rename _MyT unless you comment out the "MyFunction()" line or the "CREATE PROCEDURE" line.
Tagged:

Comments

Sign In or Register to comment.