SqlDbx Forum

SqlDbx

You are not logged in.

#1 2015-09-22 06:02:38

lantian
Member

Loss of annotation

If The process is The most front, trigger statement annotations ("-- The comment "and" / * The comment * / ") in lost during The revision comments

Such as:
1.
-- The comment
ALTER PROCEDURE [dbo].[up_cancelrun] @no_dradvice   INT
...
GO

2.
/*
The comment
*/
ALTER PROCEDURE [dbo].[up_cancelrun] @no_dradvice   INT
...
GO

3.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================   
-- Author:       lantian
-- Create date: 2015-09-22   
-- Description: The comment
-- =============================================
ALTER PROCEDURE [dbo].[up_cancelrun] @no_dradvice   INT

After execution
when again editing will find comments from the database disappeared

Last edited by lantian (2015-09-22 06:08:54)

Offline

#2 2015-09-29 04:17:55

geo
Member

Re: Loss of annotation

Offline

Board footer

Powered by FluxBB