BDG Scenario 3

lw_changeActivity.sql

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

CREATE Procedure lw_changeActivity(
      @activityId int,
  @activityTypeId int,
  @groupId int,
  @gradeScaleId int,
  @locationId int,
  @description nvarchar(50),
  @weight tinyint,
  @duedate smalldatetime,
  @maxscore smallint,
    @comment ntext
)
As
 set nocount on 
 
 update activity set activityTypeId = @activityTypeId,
        groupId=@groupId,gradeScaleId = @gradeScaleId,
        locationId = @locationId, description = @description,
        weight = @weight, duedate = @duedate,maxscore = @maxscore,
        comment = @comment 
        where activityId = @activityId
       
 return @@ERROR

Go