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

No column suggestion for CTE with row value constructor

jamieukajamieuka Posts: 6
edited January 16, 2013 1:47PM in SQL Prompt Previous Versions
Example using SQL Server 2008 supported Standard SQL syntax:

WITH T AS (SELECT * FROM (VALUES (1)) AS T (c))
SELECT * FROM T WHERE T

...then type a dot and I would expect the first suggestion to be the column name `c` but it is not shown as a suggestion at all.

Out of interest, it does appear when using this equivalent proprietary syntax:

WITH T AS (SELECT 1 AS c) SELECT * FROM T;

Comments

Sign In or Register to comment.