Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

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.