SQL Prompt V 9.3.0.6627 is removing aliases from columns during format
gvarol@corelogic.com
Posts: 90 Bronze 3
in SQL Prompt
SQL Prompt is removing already assigned aliases if the column is used in an inline table valued function and the column exists in multiple tables used in the query. The result is query is failing since the column cannot be resolved anymore.
like it changes
FROM [master].[dbo].[sp_GetColumnType]([c].[name], [c].[max_length], [c].[precision], [c].[scale], [c].[collation_name], [db].[collation_name]) )COLLATE SQL_Latin1_General_CP1_CI_AS AS [ColumnDef]
to
FROM [master].[dbo].[sp_GetColumnType]([name], [max_length], [precision], [scale], [collation_name], [db].[collation_name]) )COLLATE SQL_Latin1_General_CP1_CI_AS AS [ColumnDef]
(see attached)
like it changes
FROM [master].[dbo].[sp_GetColumnType]([c].[name], [c].[max_length], [c].[precision], [c].[scale], [c].[collation_name], [db].[collation_name]) )COLLATE SQL_Latin1_General_CP1_CI_AS AS [ColumnDef]
to
FROM [master].[dbo].[sp_GetColumnType]([name], [max_length], [precision], [scale], [collation_name], [db].[collation_name]) )COLLATE SQL_Latin1_General_CP1_CI_AS AS [ColumnDef]
(see attached)
Tagged:
Answers