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

Table-valued parameters not included in prompt

ewhippleewhipple Posts: 10
edited May 21, 2012 9:30AM in SQL Prompt Previous Versions
Howdy, again. When I create a stored procedure or function with a table-valued parameter, the parameter variable is not offered in SQL Prompt prompts.

For example:
CREATE PROCEDURE MyProc @table_parm1 tt_ID_list READONLY
AS

SELECT *
FROM
CREATE FUNCTION MyFunc(@table_parm1 tt_ID_list)
RETURNS TABLE
AS
RETURN SELECT * FROM
In both examples, when completing the FROM clause, @table_parm1 is not listed in the prompt.

Have I missed something in my configuration, or is this not supported?

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

Comments

  • Options
    Thanks for your post.

    I'm afraid table valued types are not fully supported in SQL Prompt 5.

    We have an internal case open for this, but I can't give you an estimate on when you can expect full support. For your reference the internal tracking code for this is SP-2142.

    It might help if you log a suggestion on our uservoice site, as the more popular suggestions are more likely to be implemented.

    Sorry I can't be of more help.
    Chris
Sign In or Register to comment.