Provides intelligent code completion for SQL Server editors.
Moderators: David Atkinson, Anu Deshpande, Luke Jefferson, Paul Stephenson
I prefix all my managed stored procedures with msp (i.e. mspManagedSP). When I type EXEC m the suggestion list does not list any of the managed stored procedures. Am I doing something wrong or is this by design?
Thanks for your help!
- Posts: 6
- Joined: Tue Aug 22, 2006 7:47 pm
I asked this in January 2010 and received the following reply:
Unfortunately SQL Prompt v4 does not yet support CLR types (including xml) and so it fails to prompt suggestions.
I have logged this as a feature request in our internal tracking system whose id is SP-2866.
It seems that this feature did not make it in the new release yet
- Posts: 17
- Joined: Sat Jan 30, 2010 7:46 pm
It also doesn't list CLR functions in the suggestions.
I have an aggregate function using CLR which concatente strings delimited with commas and I use it quite frequently.
Do you plan to add it?
- Posts: 9
- Joined: Tue Mar 16, 2010 7:56 pm
Unfortunately, we were unable to do any work on the parser in this release so support for CLR types (and XML) will not be in SQL Prompt 5.
Red Gate Software
- Posts: 33
- Joined: Fri Sep 17, 2010 10:26 am
Return to SQL Prompt 5 EAP
Who is online
Users browsing this forum: No registered users and 0 guests