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

No prompting for columns of UTT table variables

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

CREATE TYPE tt_ID_list AS TABLE(
	ID t_imis_id NULL,
	AUTOSEQN int IDENTITY(1,1) NOT NULL PRIMARY KEY
)
(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 5.3.2.2 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
ewhipple
0

Comments

1 comment

Sort by
  • Eddie D
    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
    Eddie D
    0

Add comment

Please sign in to leave a comment.