Feature Request -- Parameter Prompting

MikeONeill

When you use a function , the tooltip shows you the parameters that the function expects

As you start to enter the various parameters , the prompting stops and the tool tip disappears . I assume the SQL is in an inconsistent state and stops prompting.

I got around it by having a second line with the function on is so I could see the tooltip on that one

It would be really nice if the prompting continued a la VS Intellisence , as each parameter is added and then a comma a prompt for the next parameter shows .

I really am lazy !!

Cheers

Mike

Ben Pinchen

Thanks for your feedback. SQL Prompt should work as you wish. When using a user defined function SQL Prompt should prompt you with the parameters needed for that function. This should happen in the way that you describe, as you type the parameters and then a comma SQL Prompt should move to the next parameter in the tooltip. If you do a simple test with an Adventureworks function you should see this e.g.

SELECT dbo.ufnGetProductDealerPrice()

When you place the cursor in the (), SQL Prompt should highlight the first parameter needed and then move onto the next one after you type a comma. Does this work for you?

If this works but you're still having issues with a certain function could you give me an example?

Ben Pinchen

Do you still need assistance with this posting or have you been able to get the parameter prompting working?

MikeONeill

No Problem now Thanks