If you type... EXECUTE [dbo].[Your_Sproc_Name] ...and then press tab you should get some helpers for filling in the sprocs inbound values. The IntelliSense comes from a calculation made when SSMS is spun up and thus if you've added stuff since the spin up it may not be reflected in the IntelliSense. To jog a refresh in the IntelliSense, click Ctrl-Shift-R. This should do the trick UNLESS you are using Redgate SQL Prompt and then the hotkey is Ctrl-Shift-D instead and the other won't fly.
No comments:
Post a Comment