spAddUpdateAthleticSettings
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ClientSitesID | int | IN | |
| @CurrentSeason | uniqueidentifier | IN | |
| @HomeTeamName | nvarchar(256) | IN |
Definition
Copy
Create procedure dbo.spAddUpdateAthleticSettings
@ClientSitesID int,
@CurrentSeason uniqueidentifier,
@HomeTeamName nvarchar(256)
AS
delete from ATHLETICS_SETTINGS
where clientsitesid=@ClientSitesID
insert into ATHLETICS_SETTINGS(ClientSitesID, CurrentSeason, HomeTeamName)
values(@ClientSitesID, @CurrentSeason, @HomeTeamName)