SQL Server - Store Procedure

 

 

 

Greetings mate, 

 

I'm new to sql server stored procedures

- I have 2 tables tasksTbl and staff_TasksTbl

- tasksTbl primary key is an identity column

- When inserting a row into tasksTbl I want to get the ID for the new inserted row using SCOPE_IDENTITY() and use it into a new insert command that will add a row into staff_TasksTbl

 

 

I need to know whats the problem in this procedure

 

 

 CREATE PROCEDURE insertTask

(@TaskName varchar(20),

@TaskDescription varchar(20),@Rating int,

@Status varchar(20),@StartAt varchar(20),

@EntAt varchar(20),@EventID varchar(20), @StaffID varchar(100)

)

AS declare @TaskID int

SET NOCOUNT ON

insert into TasksTbl(TaskName, TaskDescription, Rating, Status, StartAt, EntAt, EventID)values(@TaskName, @TaskDescription, @Rating, @Status, @StartAt, @EntAt, @EventID)

 select @TaskID = SCOPE_IDENTITY()

 

insert into staff_TasksTbl(TaskID,StaffID)values (@TaskID, @StaffID)

GO

 

 

Thanks in advance.