spAddUpdate_ATHLETICS_ROSTERS

Parameters

Parameter	Parameter Type	Mode
@ID	int	INOUT
@TeamID	int	IN
@EA7RecordID	int	IN
@FirstName	nvarchar(256)	IN
@LastName	nvarchar(256)	IN
@Position	nvarchar(256)	IN
@Number	nvarchar(256)	IN

Definition

Copy


      CREATE PROCEDURE [dbo].[spAddUpdate_ATHLETICS_ROSTERS]

          @ID int output,
          @TeamID int,
          @EA7RecordID int,
          @FirstName nvarchar(256),
          @LastName nvarchar(256),
          @Position nvarchar(256),
          @Number nvarchar(256)
      AS
      SET NOCOUNT ON
      IF @ID = 0 BEGIN
          INSERT INTO ATHLETICS_ROSTERS (
              [TeamID],
              [PlayerEEID],
              [FirstName],
              [LastName],
              [Position],
              [Number]
          )
          VALUES (
              @TeamID,
              @EA7RecordID,
              @FirstName,
              @LastName,
              @Position,
              @Number
          )
          set @ID = @@Identity;
      END
      ELSE BEGIN
          UPDATE ATHLETICS_ROSTERS SET 
              [TeamID] = @TeamID,
              [PlayerEEID] = @EA7RecordID,
              [FirstName] = @FirstName,
              [LastName] = @LastName,
              [Position] = @Position,
              [Number] = @Number
          WHERE [ID] = @ID

      END