select * from emp ap_
select * from emp go ap_
SELECT * FROM myTable EXEC ap_
Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal
Comments
Could you kindly check following settings:
1. SQL Prompt 4 --> Options --> Suggestions --> Type of suggestion --> Check List system Objects
2. SQL Prompt 4 --> Options --> Inserted Code --> Objects and Statements --> Check Insert parameters for functions and stored procedures.
Kindly let us know whether above settings resolves your issue.
Product Support
Redgate Software Ltd.
E-mail: [email protected]
and if i type exec <control+space> or alter procedure <control+space> it works.
But exec sp_helptext <control+space> doesn't work anymore in v4.
too bad, because it's very usefull to have a quick view on a SP
I have added this issue in our internal tracking system and will be addressed in our future release. ID for this issue is SP-2777.
Sorry for the inconvenience caused by this issue.
Product Support
Redgate Software Ltd.
E-mail: [email protected]
i can't have suggestion for SP on a new line alter i type ap_
for exemple :
but this work
it was fine on v3...
If you type in:
you should get all the suggestions that match your input.
Mike