text: ﻿/*
  ??????????????????????????????????????????????????????????????????????
  ?|
  ?|	Procedure Name:	ag_test_ins
  ?|
  ?|	Description:	Inserts new rows into the table test
  ?|
  ?|	@Author:		Auto Generated
  ?|	@Createdate:	2/13/2018
  ?|
  ?|	@Input Param: 	@application_id		int		=	ApplicationId
  ?|			@application_method_id	int		=	ApplicationMethodId
  ?|			@application_version_id	int		=	ApplicationVersionId
  ?|			@default_method_input	xml		=	DefaultMethodInput
  ?|			@default_method_output	xml		=	DefaultMethodOutput
  ?|			@arg_user_id		varchar(100)		=	OpCode
  ?|
  ?|	@return:     	select @@rowcount - 1 if add is a success
  ?|
  ?|	example:	exec ag_test_ins
  ?|
  ????????????????????????????????????????????????????????????????????
  */
  CREATE PROCEDURE [dbo].[ag_test_ins]
  (
  	@application_id int,
  	@application_method_id int,
  	@application_version_id int,
  	@default_method_input xml,
  	@default_method_output xml,
  	@arg_user_id varchar(100)
  )
  AS
  	BEGIN
  			INSERT	INTO	test
  			(
  				[application_id] , 
  				[application_method_id] , 
  				[application_version_id] , 
  				[default_method_input] , 
  				[default_method_output] 
  				)
  				Values
  				(
  				@application_id , 
  				@application_method_id , 
  				@application_version_id , 
  				@default_method_input , 
  				@default_method_output 
  			);
  			select @@identity;
  
  	END
  
  