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