Creation of documentation automatically when creating or updating a stored procedure
-
hi All, Is there any setting in SQL Server when I am creating a stored procedure, it can automatically generate documentation for me that who is creating who is updating, date time of creation and update etc instead me typing all that by myself. Just like in the below example.
/********************************************************************************************************/
/* NAME : [Usp_Get_vvvvvvById] */
/* PURPOSE : THIS STORED PROCEDURE RETRIEVES LIST OF vvvvv codes */
/* TABLES USED: */
/* [dbo].[xxxxxxxxxx] , [dbo].[xxxxxxxxxxxxxxx] */
/* VERSION HISTORY:- *//* VERSION NUMBER| DATE | AUTHOR | CHANGES */
/* 1.0 | 10/18/2017 | xxx | INITIAL VERSION */
I want it can be generated automatically instead of me typing every-time, anybody can help me please, any help can be a great help - thanks in advance. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."
-
hi All, Is there any setting in SQL Server when I am creating a stored procedure, it can automatically generate documentation for me that who is creating who is updating, date time of creation and update etc instead me typing all that by myself. Just like in the below example.
/********************************************************************************************************/
/* NAME : [Usp_Get_vvvvvvById] */
/* PURPOSE : THIS STORED PROCEDURE RETRIEVES LIST OF vvvvv codes */
/* TABLES USED: */
/* [dbo].[xxxxxxxxxx] , [dbo].[xxxxxxxxxxxxxxx] */
/* VERSION HISTORY:- *//* VERSION NUMBER| DATE | AUTHOR | CHANGES */
/* 1.0 | 10/18/2017 | xxx | INITIAL VERSION */
I want it can be generated automatically instead of me typing every-time, anybody can help me please, any help can be a great help - thanks in advance. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."
I do not have any exact answer, however, this could be interesting: https://www.red-gate.com/simple-talk/sql/t-sql-programming/documenting-your-sql-server-database/ https://social.msdn.microsoft.com/Forums/sqlserver/en-US/bf682ea7-880b-4527-b7ad-112008836580/free-sql-server-documentation-tools?forum=sqldocumentation
-
hi All, Is there any setting in SQL Server when I am creating a stored procedure, it can automatically generate documentation for me that who is creating who is updating, date time of creation and update etc instead me typing all that by myself. Just like in the below example.
/********************************************************************************************************/
/* NAME : [Usp_Get_vvvvvvById] */
/* PURPOSE : THIS STORED PROCEDURE RETRIEVES LIST OF vvvvv codes */
/* TABLES USED: */
/* [dbo].[xxxxxxxxxx] , [dbo].[xxxxxxxxxxxxxxx] */
/* VERSION HISTORY:- *//* VERSION NUMBER| DATE | AUTHOR | CHANGES */
/* 1.0 | 10/18/2017 | xxx | INITIAL VERSION */
I want it can be generated automatically instead of me typing every-time, anybody can help me please, any help can be a great help - thanks in advance. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."
I presume that you mean when you are in an editor and start a new proc. Rather certain that Visual Studio provides that straight out of the box. Certainly has for a very long time for other languages like C#. There is or at least was something named something like 'template' which was invoked every time one created a file of a new type.