Generate SQL: Procedure CALL
- Dominant language
- Java
- Stars
- 51.8k
- Forks
- 4.4k
- Avg merge
- 3d 8h
- Merged PRs (30d)
- 188
Description
**Is your feature request related to a problem? Please describe.**
It would be very useful to get the procedure call with all the arguments declared and part of the call.
Current call look like:
`USE [fresh_altdb]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[uspGet_PartNumber]
SELECT 'Return Value' = @return_value
GO
`
**Describe the solution you'd like**
Right click on a Procedure > Generate SQL > CALL produces sql like MS SQL Management Studio does.
Output of MS SQL MS:
`USE [fresh_altdb]
GO
DECLARE @RC int
DECLARE @sPartNumber nvarchar(100)
-- TODO: Set parameter values here.
EXECUTE @RC = [dbo].[uspGet_PartNumber]
@sPartNumber
GO
`
**Describe alternatives you've considered**
I currently use MS SQL Management Studio for generating these calls.
Contributor guide
Assessment
This issue has not been assessed yet.