Using Microsoft SQL Server 2014 and Heidi 9.3.0.4999 right click and 'create stored routine'
Heidi generates following code:
CREATE PROCEDURE "test"(IN "@MyLimit" INT)
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
SELECT * FROM Country ORDER BY CountryID OFFSET 0 ROWS
FETCH NEXT @MyLimit ROWS ONLY
END
This cannot be saved. Correct code should be:
DELIMITER //
CREATE PROCEDURE clipdogTest2
(
@MyLimit INT
)
AS
BEGIN
SELECT * FROM Country ORDER BY CountryID OFFSET 0 ROWS
FETCH NEXT @MyLimit ROWS ONLY
END//
DELIMITER ;
Is there some way to change the 'snippets' used in create procedure?