dbeaver / dbeaver/dbeaver

Generate SQL: Procedure CALL

Open
#8,633 2 comments 0 reactions 0 assignees View on GitHub
x:mssql xf:metadata
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.