How can we help you today? How can we help you today?

Expanding wildcard for @table variables not displaying computed columns

The expand wildcard feature is not working for @table variables. If I declare a @table with computed columns, then expand the wildcard, only the non-computed columns will be shown. For example:

declare @t table ( C1 varchar(9) ,C2 as ('a' + C1) ,C3 as ('z') ) select * from @t

If I expand the asterisk, it'll show:
select C1 from @t
All other tables don't have this issue. I am using version: 9.4.8.7733.
ggeier
0

Comments

2 comments

  • Tianjiao_Li
    Thanks for reporting this issue! It's logged as SP-7431 in our internal bug tracking system now. Please keep an eye on the release note!
    Tianjiao_Li
    0
  • DBAJohnny
    I am having this exact issue in SQL Prompt version 10.1.5.14730.
    DBAJohnny
    0

Add comment

Please sign in to leave a comment.