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

No prompting for columns of UTT table variables

ewhippleewhipple Posts: 10
edited May 17, 2012 3:50PM in SQL Prompt Previous Versions
Howdy, all. When I'm working with a table variable of a user-defined table type, SQL Prompt does not offer the variable's columns in the prompt.

Here's an example. When I typed the FROM clause, table variable @foo was properly included in the prompt. When I went back to fill in SELECT clause, "f" was the first prompt item, but it listed no columns. I typed "f." by hand, and only IDENTITYCOL, ROWGUIDCOL, and my snippets list were prompted, no columns.
DECLARE @foo tt_ID_list

SELECT  f.id
FROM @foo AS f
And here are the type definitions
CREATE TYPE t_imis_id FROM varchar(10) NULL

	ID t_imis_id NULL,
(If instead I give @foo an explicit, local definition, prompting works correctly as usual.)

Is this a configuration issue, or a bug, or does SQL Prompt not yet cover this situation?

I'm using SQL Prompt with SSMS 2008 on Windows 7 64-bit. The server is SQL Server 2008 non-R2 on Windows Server 2008 R2 64-bit.

Microsoft SQL Server Management Studio 10.0.5500.0
Microsoft Analysis Services Client Tools 10.0.5500.0
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 8.0.7601.17514
Microsoft .NET Framework 2.0.50727.5456
Operating System 6.1.7601


  • Options
    Eddie DEddie D Posts: 1,789 Rose Gold 5
    Thank you for your forum post.

    I suspect that this is a bug within SQL Prompt. Therefore I submitted Bug Report SP-4419 to highlight the issue to the SQL Prompt Development Team. Hopefully they will investigate and geenrate a fix for the issue.

    Thank you for bringing this issue to our attention.

    Many thanks
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.