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