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

SQL Prompt V is removing aliases from columns during format

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]
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)


Sign In or Register to comment.