Hi,
I have this stored procedure, but it is reported wrongly under both 'Create code' tab and 'Routine body' section.
CREATE PROCEDURE [dbo].[myproc]
@1 varchar(4000),
@2 varchar(4000),
@3 varchar(30),
@4 datetime,
@5 varchar(4000) output,
@6 varchar(4000) output
AS
BEGIN
SET NOCOUNT ON;
END
HeidiSql uses sp_helptext for the retrieval of the definition, which should report the correct definition.
Moreoever, at the beginning of the 'Create code' tab, there is this:
CREATE PROCEDURE "myproc"()
LANGUAGE SQL -- from here
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
which is not present in the sp_helptext.