Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Stored procedure created in SQL Server not shown properly in HeidiSQL #1924

Open
Nj6EST opened this issue Mar 19, 2024 · 0 comments
Open

Stored procedure created in SQL Server not shown properly in HeidiSQL #1924

Nj6EST opened this issue Mar 19, 2024 · 0 comments

Comments

@Nj6EST
Copy link

Nj6EST commented Mar 19, 2024

Preconditions

  • HeidiSQL version: 12.6.64
  • Database type and version: SQL Server 2016, 2017, 2019, etc
  • OS: Windows 10

Describe the bug

When displaying stored procedure created in SQL Server using (SQL Server management studio or other tools), HeidiSQL does not show the complete stored procedure body, nor does it show the parameters.

example - the following stored procedure:

CREATE PROCEDURE dbo.usp_GetID
@A float
AS
BEGIN
/*
This procedure returns the ID of the input value
*/

SELECT ID
FROM tTable WITH (NOLOCK)
WHERE value = @A

END

In HeidiSQL, it shows the following in the routine body field:

Where value = @A

END

and the parameter tab does not show any parameters.

To Reproduce

Screenshots or Crash reports

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant