Create a stored procedure using the toad execution statement, if the last parameter has an empty string default and a multi line comment command is created, the default value and comment will be lost.
For example:
step1: Execute the following statement in toad,
create PROCEDURE [dbo].[proc_errortest] @xx varchar(1)=’’ /the default value will be lost, and the comment will be lost/
AS
select 1
step2:review the definition of the procedure proc_errortest, the result is:
create PROCEDURE [dbo].[proc_errortest] @xx varchar(1)
AS
select 1
GO