BDG Scenario 3

lw_addActivityType.sql

If Exists (Select * From sysobjects Where name = N'lw_addActivity' And user_name(uid) = N'dbo')
    Drop Procedure dbo.lw_addActivity
Go

CREATE Procedure lw_addActivity(
  @activityTypeId int,
  @groupId int,
  @gradeScaleId int,
  @locationId int,
  @description nvarchar(50),
  @weight tinyint,
  @duedate smalldatetime,
  @maxscore smallint,
  @average float,
  @stdDeviation float,
    @comment ntext,
    @activityId int OUTPUT
)
As
 set nocount on 
 insert into activity values(@activityTypeId,@groupId,@gradeScaleId,
       @locationId,@description,@weight,@duedate,@maxscore,@average,
       @stdDeviation,@comment)
       
 select @activityId = @@IDENTITY
 return @@ERROR

Go